Restrict duplicates on looping with actions

AppSheet AppSheet Q&A
1

Hi,

I have an app that sets worker’s availability.
I have managed to add multiple records at once following the instructions in the article below.

The problem I have is that once a set of available dates are set for a worker, there is nothing restricting the user from adding again the same dates for the same worker, this way ending up with multiple records for the same worker for the same day.

The actual loop is between the Bridge Table and Availability Table.

I am thinking of having a column [Test] on the Availability Table with a formula like

CONCATENATE([Worker],[Date])

…and then somehow have a condition on Add One Row action to check all concatenations of Worker and selected dates in the Enum List column in the Bridge Table against the [Test] column from Availability Table

This is where I am stuck!
Can’t figure it out how to do it.

Thanks a lot!

@Steve

1 Like
2

AlexM:

The EnumList has the following ValidIF formula:> > LIST([DR_WeekStart],[DR_WeekStart]+1,[DR_WeekStart]+2,[DR_WeekStart]+3,[DR_WeekStart]+4,[DR_WeekStart]+5,[DR_WeekStart]+6)

LIST(...) - SELECT(table[date-column], expression-that-matches-worker's-current-commitments)

See also:

1 Like