Good afternoon, Everyone:
I created an Address Book app. Each Contact can have multiple Email Addresses. In the Contact Details table, I created a VC called Related Contact Email Addresses By ContactID of type List. AppSheet graciously populates that field as Email Address records are added and associated with a Contact.
Things were moving smoothly until I saw that Email Address records became orphaned whenever I deleted a Contact without first deleting Email Addresses. Granted, orphaned records donโt negatively impact the appโs operation, but I find it distasteful from an esoteric point of view
My current solution works, but it is not efficient. I created an Action called Delete All Email Address Records referenced by Contact Detail Record. Here is a screenshot:
Iโm unsure how AppSheet executes the SELECT, but the worst case scenario is that it is a linear, brute force search. That will slow down as more Contacts and Email Addresses are added.
Well, then I thought why canโt I leverage the existing โRelated Contact Email Addresses By ContactIDโ in the Contact Details table? All of the EmailAddressIDโs are right there, courtesy of AppSheet. So, I changed the Action to this:
However, I receive an error saying, in effect, that the result of the SELECT is not a list. It wonโt tell me what it returns, but I suspect that it is a List of Lists.
Is there a way to flatten it?
Thank you,
Brian
Solved! Go to Solution.
For Referenced Rows, try just:
[Related Contact Email Addresses By ContactID]
For Referenced Rows, try just:
[Related Contact Email Addresses By ContactID]
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |