I tried using the formula on the KoBoToolbox documentation here to add direct hyperlinks to collected media in Excel but it does not work.
After tinkering around with the formula, I managed to get something that works. I tried looking for a place to raise the issue, but I can’t seem to find any apart from the community. Looks like the repository for the documentation is hosted privately so there’s no way to suggest an edit.
The formula in the documentation is:
=HYPERLINK(“https://kc.humanitarianresponse.info/attachment/original?media_file=username/attachments/”&A2”).
What worked for me:
=CONCATENATE(HYPERLINK(“https://kc.humanitarianresponse.info/attachment/original?media_file=username/attachments/”),A2)
Is there a way to suggest an edit on this?