Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 28, 2022 04:44 PM
Hello guys! I am new to Airtable, and have been absolutely amazed by it’s possibilities. However, there is one specific thing where I got completely stuck for several hours and no YouTube videos or Forum topics helped me get through.
I am practicing on a table for a Car Dealership. Each record has 5 columns with Car Details, and then a Single Select Field where we can choose from “Available”, “Reserved” and “Sold”.
Then I have another table called “Car Dealership Statistics”, and here I would like to count how many times my cars went into “Reserved” and how many times they went into “Sold”. These numbers can be different because people can abandon their Reservations and the car becomes Available again.
I wanted to tackle this with a Counter column, a Formula column ( Counter+1 ) and an Automation that increases Counter by Formula when the field = Reserved, and then same when field = Sold.
However, I keep getting the message in my Automation that the Formula column can not be used to Dynamically increase Counter because it is computed. Any ideas?
Solved! Go to Solution.
Aug 29, 2022 10:21 AM
Hm, not sure if I fully understand the question. You can see on this screenshot, the Counter is set to 0 and the Formula is returning a 1. ( Counter+1 )
Aug 29, 2022 10:23 AM
Try doing the Trigger Test again and post a screenshot of the result please
Aug 29, 2022 10:28 AM
I just realised what the mistake was. I based my Trigger Condition on Status from the “Car Information” table, instead of the Lookup field in the “Car Dealership Statistics” table. Can’t believe I haven’t noticed for so long.
Thank you Mohamed!
Also thank you Scott and Alexey!
Aug 29, 2022 10:29 AM
I thought it might be something like that :slightly_smiling_face:
Aug 29, 2022 10:31 AM
Yeah, you suspected immediately. Spot on!
Aug 29, 2022 10:43 AM
That was going to be my next suggestion. Lol.