Photo link on kobo

User Support Data Management
, ,
1

Bonjour communité,

J’ai besoin d’aide.
J’essais depuis ce matin de créer des liens de mes photos dans mon fichiers xls mais je n’y arrive pas. Pourtant je crois avoir utiliser le lien standard.

= HYPERLINK (“https://kc.humanitarianresponse.info/attachment/original?media_file=username/attachments/” & A2 ")

Cordialement

2

@black, have you gone through our support article Downloading Photos and Other Media?

3

@Kal_Lam oui, c’est de cette adresse que j’ai tiré le lien ci dessus.
Mais dans mon fichier excel j’ai téléchargé la formule ne fonctionne pas.

4

@black, would you mind sharing with me the following (through a private message) so that we could have a closer look at it:

  • Username
  • Project name
  • Server

Also please share your xlsform that holds the hyperlink.

6

@black, would you mind using this formula as shown in the image shared below:

=CONCATENATE(HYPERLINK("https://kc.humanitarianresponse.info/attachment/original?media_file=username/attachments/"),C2)

image
image1705×162 14 KB

From the formula shared above, please be sure you use the correct server URL:

https://kc.humanitarianresponse.info if you are using the OCHA server and https://kc.kobotoolbox.org if you are using the HHI server.

Similarly, please be sure to change your username and also the cell position.

Kindly please be informed that we will update our support article soon.