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

User Support Data Management
, , ,
1

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
2

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!

3

@funmitoblessed, kindly please be informed that we have updated the support article based on your inputs.

Thank you for providing the updated formula. This has helped a lot of our members in solving the issue. We would expect the same in the upcoming days too.

1 Like