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 |
---|---|---|---|
7381caf6 | 1 | phil@listersbrewery.com | Aberdeenshire , Avon , Lancashire |
f5f491e7 | 2 | hilary@listersbrewery.com | Devon |
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 โhilary@listersbrewery.comโ.
Many thanks
Phil
Try:
ANY(
SELECT(
User Assign[User Id],
IN([_THISROW].[County], [Counties To Include])
)
)
Hi Steve, that works great. Thank you. The result of the expression is correct when I test it but the result is not appearing in the Assigned User column on the main table. The intention was to be able to create slices and therefore call list for each user from that column.
Many thanks
Phil
What does that mean?
Set the App formula for the Assigned User column to the expression I provided.
Hi Steve,
Once each row has been assigned a user I can create slices based on that. Then I can create lists of outlets to be telephoned by user.
The result is still not apprearing and appsheet is automatically reverting to enum fopr Assigned User column.
Please provide a screenshot of the Assigned User column configuration.
Where is the result still not appearing?
Where is this occurring?
The result is not appearing on the main google sheet in column Assigned User. The screen shot shoes email as I changed it but it reverts to enum after saving.
I think your problem would benefit from the more direct help support@appsheet.com can provide.
User | Count |
---|---|
40 | |
36 | |
32 | |
23 | |
16 |