Assign useremail() based on user input

[Phil_Waite]

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

[Steve]

Try:

ANY(
  SELECT(
    User Assign[User Id],
    IN([_THISROW].[County], [Counties To Include])
  )
)

[Phil_Waite]

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

[Steve]

Phil_Waite:

call list for each user from that column

What does that mean?

[Steve]

Phil_Waite:

the result is not appearing in the Assigned User column on the main table

Set the App formula for the Assigned User column to the expression I provided.

[Phil_Waite]

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.

[Steve]

Please provide a screenshot of the Assigned User column configuration.

[Steve]

Phil_Waite:

result is still not apprearing

Where is the result still not appearing?

Phil_Waite:

appsheet is automatically reverting to enum fopr Assigned User column

Where is this occurring?

[Phil_Waite]

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.

[Steve]

I think your problem would benefit from the more direct help support@appsheet.com can provide.

[Phil_Waite]