I have Vehicle Equipment data related to Maintenance Logs. Although Vehicle equipment does not necessarily have a geographic component, I have created points for each of the vehicles in order to use Survey123. The maintenance log is a table related to the vehicle point. The vehicle points will not be edited nor will new points be added, I just want to create new maintenance logs using Survey123.
I have gone through all the steps to set up my existing feature service for use in Survey123; I use GlobalID (from the Vehicle Point) as Primary Key and I have a MaintID (Guid field from Maintenance Log) as the Foreign Key, I have the Maintenance Log set in the form_id, and I have no errors when I publish my survey.
My survey is all set up to create new maintenance logs, except I would like to auto-populate my MaintID field using the GlobalID from my Vehicle Points so field staff will not have to, and I want this all done using Survey123. I do have field staff select the Equipment Name (its a domain) with each new maintenance log. This is a unique field and each equipment name has an associated GlobalID from the Vehicle Point.
If field staff enter in the Equipment Name, is there an XLSForm expression that could pull the GlobalID that is associated with that Equipment Name, and then populate the MaintID field with that GlobalID? I am new to XLSForms. Or is there another way? I have attached an excel table that lists all the equipment names with associated GlobalID to maybe better explain and I have attached my XLSForm from my survey.