Thanks @Josh
Is there a workaround in the meantime?
PowerBI does get the other columns, including [#“formhub/uuid”] and [_uuid] .
So I’ve tried creating a custom column and build the URL based on that.
Formula:
"https://kc.humanitarianresponse.info/media/original?media_file=MyKoboUsername/attachments/" & [#"formhub/uuid"] & "/" & [_uuid] & "/" & [#"group_photo1/input_photo1"]
Details:
- “formhub/uuid” is always the same.
- “_uuid” changes per row (i mean it changes for each form submission).
- “group_photo1/input_photo1” is the name of the column that holds the filename (eg. 1638903629888.jpg ).
The custom column generates a perfectly formed URL. But it only works in a single instance belonging to a recently submitted form (using ODK Collect).
Previously submitted entries that were also submitted via ODK Collect for some reason don’t work and the browser loads a page that says “Attachment not found”.
I know that the culprit is the [_uuid]. Because it matches perfectly (i can see it in the json file) in the single case where it works and it doesn’t match in the other cases where it does not work. It’s like it’s been changed or something.
Now I’m suspecting this could be related to these entries having been updated recently via the web. I needed to change some of the details so I edited the forms in KoboToolbox web. I did not update the one that is currently working. Does my suspicion make any sense ?
