Multi Select Checkbox Best Approach

If I’m understanding correctly, you want to use a series of checkboxes to move your records through different views. If so, I believe you can simply this quite a bit by eliminating the ‘back to stage X’ checkboxes.

For example,

• Record is created and placed in “stage 1”. In the stage 1 view, filter records that do not have “Stage 1 Completed” checkbox checked.
• Within stage 1, you hide all checkbox fields with the exception of ‘Stage 1 Completed’ which you can check when that stage is completed. It will then be removed from the stage 1 view.
• In Stage 2 view, filter to only show records with “Stage 1 Completed” checked. In the view have “Stage 2 Completed” and “Stage 1 Completed” checkbox fields showing. If you complete stage 2, check that box. If you need the record to go back to stage 1, uncheck the “Stage 1 Completed” checkbox.

Repeat with as many stages and checkboxes as you want.

Does that work for your use case? It would simplify your flow quite a bit.

Cheers,
Kris

Thanks Kris for your quick response, yea I know that logic and that’s actually what I am using at the moment , however that actually came as bad workflow from our service provider , as they don’t want to tick and search again for other checkboxes and untick , they just want a button to click or a checkbox they can select to move to another stage , Is there another approach to do this ?

Having multiple select Checkbox for me is a solution, because they will have to open that field to tick and untick whatever stage they want at a time.

Thank you for your time

What they are asking for is not something efficiently built in Airtable (to my knowledge at least). It’s also not very future-proofed. (For example, adding in additional stages will exponentially increase the number of buttons you need to display).

Is it limited to 3 stages? And do you have access to the scripting block?

I think your particular challenge may be best solved in Airtable using a scripting block to change an integer field for the stage number, and triggering the script to run using the Airtable buttons.

If I were you, I might try explaining the challenges with this solution to your service provider. Is a minor convenience (which in my opinion is actually more confusing to use) more important than their data integrity? Or are hours of your time making that change worth ‘potentially’ saving them a few seconds?

Beyond that however, maybe dive in to the scripting block if you need to make it work that way. I don’t have a script for you though, haven’t spent much time with that myself.

Good luck and sorry I couldn’t be of more help, maybe someone with more experience will suggest an alternate approach =)

Thanks Again Kris for your concern, I actually appreciate you take the time and reply to me,They are limited to 3 stages, No more will be added. I tried a lot to explain that to them , however they consider that as a system not a database thing.

I am still looking for a soultion " Multi select checkbox" or other approaches to handle the ticking and unticking in one time .