Error in formula in documentation - Adding direct hyperlinks to collected media in Excel

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?

1 Like

Hi @funmitoblessed,

Welcome to the community! Thank you for flagging this out in the community! We shall test it and make changes accordingly.

Expecting the same in the upcoming days as well.

Have a great day!