Hi Every one
can some one please guide , that how we can pull data based on selection of another field , example is
we have
emp-1
emp-2
each employee is having different task assigned
emp-1 Task-1
emp-1 Task-2
emp-2 Task3
emp-2 Task4
we actually need that when the employee is selected from the field only the task related to that employee should be pulled from the data.
Please help
Neeraj
Cheers!
Hi @caneeraj,
Kindly have a look at this link Pull Data Functionality
Please let me know if you need any help with the pull data.
Best,
Yasser
1 Like
Hi @Ysr3322
Thank you for such a prompt replies , i tried but the data could not be pulled can you please check i am sending the xls form and upload file both for your kind reference.
odupload.xlsx (10.2 KB) overduecollection.xlsx (11.2 KB)
Thanking you in anticipation
Neeraj Cheers !
Hi @caneeraj,
It is my pleasure.
I’ve found the following issues in your form:
1- The pre-loaded data file should be in CSV format not XLS. I’ve converted it odupload.csv (335 Bytes)
2- Pulldata function should be in the calculation column not in the choice filter
3- Pulldata function considers the pre-loaded data as string and the question to check for information to match in your form is “integer”, therefor you have to convert it to “string” by adding a calculation question. Kindly see row 8
overduecollection_Solved.xlsx (11.4 KB)
The form should work perfectly now.
Lest me know if you need any help.
Best,
Yasser
2 Likes
Hi @Ysr3322
Thank you once again for helping me.
this was solved , indeed you helped to solve a major problem for us
Thank you once again
Neeraj
Cheers !
3 Likes
Hi @caneeraj
The pleasure is mine.
Best,
Yasser
2 Likes
Hi @Ysr3322
I am again in need of your help , in the above example can we use 2 external file and pull the data based on condition
like above loan id x name ( row number 7 ) , if we insert type of visit that if type of visit is 1 then pull data from od sheet as above in example and in case it is 2 then pull data should be from another external file which will be uploaded in media
please guide
Cheers !
Neeraj
HI @caneeraj
I noticed that you had asked this question on two different topics. As such I will leave the other one in which has been answered. To however ensure that you are also answered on this side; unfortunately, this is not possible.
Stephane