+13Hello Community,
I have a table with events and a linked table with needs for the events. Different needs can be assigned to each event. Each event and each need has a status. I would like that if all needs that are assigned to an event have the status "delivered" or "declined", that the status of the event changes to Needs processed.
Does anyone have an idea how I can implement this?
Best regards
Mirko
Best answer by Alexey_Gusev
Hi,
add count field, with filtering, Where Status is not delivered AND Status is not declined.
You can also add another unfiltered count (to avoid setting the same status for records without linked needs).
Then you can use formula if({CountFiltered}=0, 'Needs processed')
If you want the Status field to be Single Select, not formula, you should set automation with trigger by condition and update record action.
+25Hi,
add count field, with filtering, Where Status is not delivered AND Status is not declined.
You can also add another unfiltered count (to avoid setting the same status for records without linked needs).
Then you can use formula if({CountFiltered}=0, 'Needs processed')
If you want the Status field to be Single Select, not formula, you should set automation with trigger by condition and update record action.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.