SOLVED - I did not have the form based on the Parent details ie the User Sheet. So no matter that I can see the details in the data editor, they cannot be passed on to the sheet via the Columns components in the form. I have created the form off the Users sheet & the details are being passed along.
It would be noce to be able to pass the Looked Up Values to the sheet, perhaps you can?
My app’s URL:https://pqhmq.glideapp.io/
Thanks in advance for any help solving this! It’s been driving me nuts for a few days!
I have a User sheet related to an Accesslog sheet. These sheets are related: User can have many access check ins - Access check in can only have 1 User. In the data editor in the Accesslog sheet I have Lookup fields bringing in User names, address & mobile number. These are all clearly visible in the data editor.
In the Check in Form which is based off the Accesslog sheet I have Column Values selected from the “UserName”, “Address”, “Mobile” lookup data editor fields, these are assigned to the respective Sheet columns “User_Full_Name”, “Address” & “Mobile”.
However these fields are not populated on the submission of the form. The signed in user email is populated correctly, but the balance of the info does not come through.
Any help is greatly appreciated.
Thank you Brad.