LinkedIn
Twitter
Looking for feedback on my expression that isn't producing any value for the column.
Trying to auto compute a list of emails that meet criteria based on their counties & subscribed services aka ask locah.
"The list of values of column 'primaryEmail' ....from rows of table 'Users' ....where this condition is true: (ALL these statements are true:
........1: (The value of 'County' from the row referenced by 'Unique ID') is one of the values in the list (The value of column 'Counties')
........2: (The value of 'Requested Service' from the row referenced by 'Unique ID') is one of the values in the list (The value of column 'Subscribe_Ask_LOCAH')) "
Solved
1 ACCEPTED SOLUTION
Used virtual columns, wrote the value produced to a new column and then disabled the virtual column for rows that have processed. Then used appscript to split lists of phones & emails and add to new table, just processing new rows and called by appsheet. Then used new table to process emails & SMS to achieve initial goal.
