Hi all, I have an application where is used calendar events, those events are related to a google calendar event. I select the atendees based in a table of users (personnel) and patients, both tables have ID_usuario and ID_paciente as key respectively, I need a way to select the atendees of the event visually (because the column has a dropdown select table (Enumlist) with suggested values stablished to show the mails) by fullname but with the mail stored in the atendees column of the calendar event table, but I have the keys stablished as explained before. Is there a way to do it without using bots or modifying the keys of both tables?
What I wrote about modifying the table keys is because the rest of the application works with those IDs
Thanks @Steve , I didn’t know that appsheet was smart enough to select the mail by doing the reference to the corresponding table, I thaught that the ref type only was able to select on labels ansd keys
Sorry @Steve , thanks again for your help but I have another problem, your suggestion worked flawless if I select the atendees columns as a ref, but inmediatly after I switch to an enumlist and no matter how I have keys and labels, the atendees column saves the literal value of the suggested value instead of the mail and obviously doesn’t save the event for an error