Link to url from pulled data

User Support Form Building
, , ,
3

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:

image
image993×612 90.1 KB

4

Hi @jborruel,

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

image
image1618×347 18.3 KB

5

That is not my form!!!

I attach here below the image of my form:

image
image1311×237 9.74 KB

6

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.

7

Hi @jborruel,

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

cc: @martijnr

8

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:

image
image1837×311 15.1 KB

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

image
image805×665 35.8 KB

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

Best regards

2 Likes
9

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

image
image1159×142 8.67 KB

Which results in providing the right link to the url :

image

Thank you!

2 Likes
10

Cool! nice to know, thanks for sharing that

1 Like
11

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:

image

Data entry screen as seen in Enketo:

image
image619×540 15 KB

Reference xlsform:

url-widget-dynamic.xlsx (7.7 KB)

12

HI @jborruel

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

Cheers !

Neeraj

13

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

14

@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.

15

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

2 Likes
16

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

image
image940×140 5.01 KB

image

thank you so much for help

17

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

image
image821×219 7.22 KB

Thank You.

18

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

1 Like
19

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

20

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

1 Like
21

Hi @Josh

Thanks so much, I learn new thing. is function pulldata() always using external csv? My plan is using list in choice tab without external CSV.

or external csv can import in online koboform?

Thanks in advance.

Best,
Budi

1 Like
22

Sorry for previous.

Thanks so much it works, I also read this post Uploading a csv file (IDs) - User Support / Form Building - KoBoToolbox Community Forum

Help me so much.

Best,
Budi

1 Like