I have already existing guest and I want to to pull image and other fields when new appointment is clicked and guest name is selected. Can’t seem to figure this out
I think you might need a column in the User Table for a row ID of the row you need to pull from and another column with a relation to it.
When user clicks on a new form button, add an action that will be writing the row ID you need to this User’s row ID reference column. Then, use data from that relation as default values for form fields.
Let me know if that helps.
1 Like
I have all that setup. My challenge is, when a guest is selected from the dropdown, I would like to pull a pre saved image into the form or/and into the scheduled visit table.
I want to be able to pull in guest image.
The choice component should write the Row ID of the user to the table as the Value. Then you need a relation column to link that ID back to the user table and a couple of lookup columns to retrieve the name and image from the relation.
I’m not sure I understand this, the choice component links to the visitor table and is writing to the visitor name column. I am hoping to be able to auto load the associating image of that selected visitor. I tried telling the image component to call from visitor image lookup, but it pulls the first image in the first roll.
Just curious, why do you need to see that image again when it’s in the visitor name choice component already?
I don’t know if it works, but maybe try a custom collection pointing to the visitors table, and then filter by the chosen visitor’s rowID (don’t use names for these things, they are not unique, you can always lookup the name later).
Or, write the choice component to a user-specific column in your User Profiles table, then do a relation & lookup there to get the visitor’s image. This method allows you to temporarily exit the sandbox environment of the form.
3 Likes