-
max123jotAsked on September 25, 2016 at 9:42 AM
can i
populate a field (ie attending name) based upon the value of another field (ie institution)
thanks
-
Elton Support Team LeadReplied on September 25, 2016 at 11:13 AM
Yes, that's possible. Here's a guide for that: https://www.jotform.com/help/286-How-to-Pass-Field-Value-to-Another-Field
You can also perform calculations and populate it to another field base on the user's answer from another field. Guide: https://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-Field-Using-Conditional-Logic
Hope this helps!
-
max123jotReplied on September 25, 2016 at 11:27 AM
yes the above is correct, but i do not think i was explicit enough in my question
restated:
as the field values are different, i am asking again more specifically
populate a field (ie attending name) (dr. abc)
based upon the value of another field (ie institution) (hospital abc)
this may require a "look up table"
thanks
Page URL:
-
David JotForm Support ManagerReplied on September 25, 2016 at 1:51 PM
Do you meant to consult data from another source? If that is the case, this is not possible. You will need to download the full source code of your form: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form
Then hire a developer to create you the proper script to connect to your database, and pull the information into your fields, then upload the solution to your own server.
-
max123jotReplied on September 25, 2016 at 2:46 PMActually a lookup table within the same form
max
... -
jonathanReplied on September 25, 2016 at 4:55 PM
Hi Max,
In your form https://www.jotform.us/form/62683444529161 can you please confirm that the "look up table" you refer to was the Matrix table field?
It is possible to perform calculation using the value from the Matrix table field.
User guide: How-to-Perform-Form-Calculation-in-the-Matrix-Field
Because you can do calculation on the Matrix table, you can also create condition rules base on the calculated value. It is possible to pass the value from the matrix table to another field in the form using the same method described on the user guide.
Let us know if there is more we can help you with.
Thanks.
-
max123jotReplied on September 25, 2016 at 6:46 PMactually one of jotform threads
https://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-Field-Using-Conditional-Logic
seems like what i would explore to see if i can accomplish this
thanks
m
... -
Elton Support Team LeadReplied on September 25, 2016 at 7:04 PM
Great! I really think that's what you needed because you can't just use calculation formula, you can also use values from different fields or just write a static text value if you prefer.
If you need further assistance, let us know.