Skip to main content

How can I have an automation (or formula) return only the first record in a manually sorted table or view? 

I have clients submitting tasks and manually sorting the tasks according to the order in which they would like them completed, and we only work on one task at a time. 

I'm trying to build an automation that changes the status of the next task ("next" is determined by the manual sort field) to "in progress" when there are no longer any tasks for that client in progress. 

How can I do this without creating views for every client? 

Hi @Mezar,
Wouldn't this work?

In the Find Records action settings,
1. Set the Find records based on setting to View and select "View"
2. Change the Maximum record limit to 1

Hi @Mezar,
Wouldn't this work?

In the Find Records action settings,
1. Set the Find records based on setting to View and select "View"
2. Change the Maximum record limit to 1


No, I want to do this without creating views for every client.

Reply


Terms & Conditions