I currently use airtable as my delivery fulfillment hub for virtual video game items where I have multiple staff take and fulfill orders via Kaban View.
The process is the record comes into a view and the first person who changes that operator name to theirs gets to take that order. The problem comes where there is latency and multiple people click and take that order within the same second, it will override the true initial person to change the field, also its possible for them to change it after the fact (the airtable history does not work well if it all happens within the same second or one staff has higher latency then the other i think)
I want to know if this is possible to build then I will look for an app developer to help.
The problem comes with latency, the app would need to have some parameters built into it where it will know what the field was changed to FIRST then override and prevent it from being changed again within the next few seconds
Would love to hear your thoughts to my issue and if can assist please let me know thank you!
Hi Brendon. It might be possible, using an intermediate step.
Do you have a pro account?
You could set up a button in a scripting block to add a record tagged with the new record id, to another table which has an autonumber field in it. In this way, the first person to press the button, which then adds the record to the table, will have the smallest autonumber value for that record, even if 2 people press the button in the same second. The table would store the new record id, and the userid of the person who pressed the button.
I don’t have a pro account myself to test it out though.