Jul 06, 2023 10:03 PM
This might be the most random formula ever, but having a hard time figuring it out/ wondering if it is even an option.
I have a list of records that represent tasks to do.
I want to have these tasks in sets of 3 records.
I dont want the tasks grouped by airtable where you see all of the various groups.
I want to have the table literally only show the current set of 3 tasks and then they have a checkbox field next to them and as you check them off they are filtered out until all 3 are filtered out and the next 3 tasks come into view and it repeats like that.
Totally not sure if this is even something that can be done, I was thinking of manually adding in set #s and filtering for that, but then I dont know how you filter just the set that is between the one that is checked off and the rest of them.
This might be a too complicated one to create, but appreciate any help, thank you!
Jul 07, 2023 05:23 PM
I've thought about it, and you're right, it would require automation to script the next three tasks to be extracted
Jul 08, 2023 07:42 AM
How would I set up this automation, do you know or is it not possible?
Jul 08, 2023 04:07 PM
In this case, three fields, automation, and the last automation requires a script to extract only three from the top list.
1. checkbox field
2. single select field
TODO
3. date field (or something that determines priority order)
Due Date
Set the first 3 tasks to "TODO"
Automation is triggered each time a task is checked
Conditional branching if "TODO" is 0 in "Find Redords
Set single select to "blank" for the 3 tasks that have already been checked
Script extracts the three tasks with the closest due dates in "Find records" and sets "TODO".
Jul 08, 2023 05:05 PM
I tired doing it a little and didn't quite figure it out /;
Let me know if you are able to give a more detailed step by step if not no biggie I understand
Jul 10, 2023 07:21 AM
Hmm, if you're willing to link all your tasks to a single record in another table, check out this base
Idea is to have an autonumber field in your tasks table and have a formula field that'll help you create "sets" for your tasks. You then ensure that all your tasks are linked to single record in another table, and then use a rollup field with the formula "MIN(values)" on the formula field I mentioned above, and make it conditional to only display records that don't have "Done" checked
You then create a lookup field to display that rollup field's value in the tasks table, and create a formula field to check whether the lookup value is the same as that record's set value. Finally, create a view that'll filter based on that formula field
Jul 10, 2023 09:23 AM
Wow thank you so much!
Is there anyway I can become an editor of that base so I can see how you created the formulas?
Jul 10, 2023 02:55 PM - edited Jul 10, 2023 02:56 PM
Great solution, @TheTimeSavingCo !
Thank you for sharing too
@TheTimeSavingCo shared the Base with us so you can duplicate it.
Jul 10, 2023 05:18 PM
Jul 10, 2023 11:18 PM
@ShoHaha thank you!! It was very fun to solve
@Jeffrey_BrianGlad I could help!