I have a sales app that uses the “Slice based on user input” example app to allocate venues to sales reps by county.
Each outlet/venue in the main table called “Full List Table” has a column “Primary Contact”. This will holds the usermail() of the user who has been allocated the venue as a potential customer. I am trying to write the expresion for this column in this table.
Venues are listed as being in a “County” which is another column in the main table.
A new table called “User Assign” holds the following 4 column headings and a user inputs the “User Id” and selects from an enumlist which counties to add to the “Counties To Include” column.
|User Unique Id||Call List Number||User Id||Counties To Include|
|email@example.com||Aberdeenshire , Avon , Lancashire|
I can’t find the expression to return in the “Primary Contact” column the “User Id” that corresponds to a match of “Counties To Include” contains value in “County” column.
For Example: If a venue is listed in the main table as having a “county” = Devon then the expression needs to look up which user id has Devon assigned to it and return in this example “firstname.lastname@example.org”.