Hi all,
I am trying to create some fields that can auto generate the data that matches the sharepoint list that I have
My goal is when the user keyed in their ID no. into the "ID no." field, their full name is auto populated to "full name" field.
1. I have a 2 text field "ID no.", "full name"
2. I have a sharepoint list that maintain the ID No. and full name.
3. I have added data connection to the form for my sharepoint list
4. I set a formula for the default value on "full name"
-> Insert field section i selected secondary data source
-> i selected full name field to be populated
-> i select filter data
-> add a condition where ID No. = "ID No."
Seeking your help to clarify if there is any wrong, as I can't get my goal.
Thanks!