Link to url from pulled data

jborruel · December 12, 2020, 12:07pm

I am trying to provide the form with a link to an url which is pulled from a .cvs file.

First I read the url to a text field, with pulled data, that works just fine as following:

text link googleMapsLink --> pulldata(‘Salida_BBDD’,‘URL_Google_Maps’,‘ID_Ficha’,${ID_Ficha})

Then, I try to fill a note field with the following data:

I edit the last line, as it tries to convert the link; I add an space between ] and { as follows:
note note_link [Google Maps] (${googleMapsLink})

But the data is not updated as desired, as remains fixed, I guess the hyperlink is only updated at form load.

Is there a workaround to pull an url from a .csv and provide a link within the form?

Thank you very much.

NoelCartONG · December 12, 2020, 1:12pm

Can you attach a section of your XLS form and CSV file? maybe with just one line of data in the csv file with an example url from a non-sensitive location.

jborruel · December 12, 2020, 10:41pm

Please find here attached the examples I have used:

Form.xlsx (13.2 KB) Salida_BBDD.csv (1.7 KB)

You are supposed to fill in just the first field, and the rest should be pulled from the .cvs, but as seen in the here below image, the link to the url in the cvs is not completed ok:

Kal_Lam · December 13, 2020, 1:30pm

Hi @jborruel,

I don’t see any pull data function being used within your xlsfrom:

jborruel · December 13, 2020, 2:42pm

That is not my form!!!

I attach here below the image of my form:

NoelCartONG · December 14, 2020, 7:46am

If you display the result of ${link} in a normal (non-URL) note does it appear correctly?
Your URL doesn’t look to have another other special characters which would be expected to cause problems. I have never referenced “text” type question in a labels. I’m not sure if its worth using a “calculate” question as an intermediate step in the case that the URL text is not getting passed at all.

Kal_Lam · December 14, 2020, 11:23am

Hi @jborruel,

It seems to be an issue with Enketo. I have tested the same and created a GitHub report here:

cc: @martijnr

jborruel · December 14, 2020, 12:14pm

Thank you both for your support.

I have made a few more tests, particurlarly the one with the calculated field, and strikes me how it doesn’t work as it doesn’t convert the link.

This is my form:

And this is the results, trying to convert the link:

Thanks again, and I will be waiting for the Enketo issue resolution.

Best regards

jborruel · December 15, 2020, 7:00pm

Solved as per @MartijnR suggestion, “With the URL widget”:

Which results in providing the right link to the url :

Thank you!

NoelCartONG · December 15, 2020, 7:53pm

Cool! nice to know, thanks for sharing that

Kal_Lam · December 16, 2020, 8:04am

Thank you @jborruel cc: @martijnr for this solution. Documenting it here so that the community could take advantage of the same (if and when needed).

In the survey tab of your xlsform:

Data entry screen as seen in Enketo:

Reference xlsform:

url-widget-dynamic.xlsx (7.7 KB)

caneeraj · May 16, 2021, 12:48pm

HI @jborruel

Can you please share the sample form , I am facing the same issue but not able to resolve.

Cheers !

Neeraj

Kal_Lam · May 16, 2021, 4:02pm

@caneeraj, sharing the other post here. Maybe it should helpful for users having similar issues:

jborruel · May 18, 2021, 6:23am

@caneeraj , were you able to solve your issue?? My sample form is no more than what I pasted in the previous posts, I don’t think my actual xls would be any more clarifying. I could try to look for it if you are still interested though.

caneeraj · May 18, 2021, 7:38pm

Hi @jborruel

Thanks for help , but I was able to resolve the issue.

Thanks for giving insight In your posts it actually helped me a lot

Cheers !

Neeraj

bwijoyo · July 27, 2021, 2:07pm

Hi @Kal_Lam thanks this is very useful.

Is there a way to display url from a list in text, I tried it but some error. Might I need your help also

thank you so much for help

bwijoyo · July 27, 2021, 2:48pm

I tried add calculate it work for label, but still how to direct to text from a list.

Thank You.

stephanealoo · July 27, 2021, 8:38pm

Hi @bwijoyo
Could you please explain a bit by showing what is not working clearly. Also could you share the XLS form that you have so that we work on it,

Regards
Stephane

bwijoyo · July 27, 2021, 10:36pm

Hi @stephanealoo

Thanks for asking, below is my xls form.

url-list rev.xlsx (10.6 KB)

Actually i want display link in text without select in the dropdown list. So from select district jump into text.

Let me know if not clear. and again nice to connect with you.

Best,
Budi

Josh · July 27, 2021, 11:49pm

Hi @bwijoyo, you can do this using the pulldata() method as follows:
url-list rev-pulldata.xlsx (8.1 KB)
urls.csv (307 Bytes)