App Structure Help - Dynamic List of Steps/Process by Endpoint
Hi all,
I have jumped into Airtable over the last few months and it has been great.
I need some assistance with how to structure something specific. I've tried a few solutions but they all have some downsides.
I will keep this generic as it gets complicated pretty fast.
I have a set of "Endpoints", which are physical devices. They have a table of their own with a couple dozen fields of misc. information.
I have another table that is a list of "Steps", essentially a process I follow. This process gets applied to each device. The catch is that not every step is needed, some steps can be performed out of order, and some steps may need to be repeated. It will change relatively frequently, and is different per device. I also need the process to be dynamic enough that I can add/remove/edit steps without making large bulk changes. I have steps in their own table, so they are easy enough to update.
I am needing to track a large amount of Endpoints (200+) and the status of each one by step.
What I have now is 3 fields on the Endpoints table:
- "Completed Steps" - reference to Steps table, allows multiple selection
- "Next Step" - reference to Steps table, allows only 1 selection
- "Remaining Steps" - reference to Steps table, allows multiple selection
This works okay and fulfills some of my requirements. I can see:
- History of what steps were completed
- List of remaining steps
- Next step to perform
What I don't like about this solution is that I have to manually add/remove items from each list. If I complete a step, I have to add it to "Completed", change the "Next Step", and remove it from "Remaining"
Because these are a dynamic link to the Steps table, I'm having trouble getting this done with automations. But I may be missing something.
Is there a way that I can maintain these "Completed" and "Remaining" steps automatically? Or another way to structure this kind of thing?
Thanks in advance
