Hi,I am trying to pre-fill two records in an Airtable form from the following column "Client Commercial Controls":If I pull up the pre-filled form, currently I can only pre-fill the one value ("Police check to be performed"), but I also want to pre-f...
I have an automation that creates a numbered sequence once a checkbox is ticked (e.g. 1, 2, 3) by updating a field using 'Length of records".The issue is it has maxed out at a 100 and I need it to continue. Does anyone know how I can continue this au...
Hi! I’d like to push the latest collaborator comments in a record to a my main table/view so that I can see what the latest comment is without having to go into the record.
My use case is that I want to be able to track comments/actions across my tea...
I have a column that is a checkbox and would like to start capturing unique ID’s in numerical order (i.e. Autonumber) for records that have a tick in that checkbox. Is this possible?
Hi Adam @TheTimeSavingCo ,No luck yet unfortunately. I created a new column with your formula above:But when I update the pre-filled form formula, only the first linked value appears rather than both. Any ideas?Thanks,Nik
Awesome thanks, that works now Adam @TheTimeSavingCo .The only issue I'm having now is step 5. I have created a separate column to capture the new unique ID, but every time new checkbox I tick, it keeps the same number whereas I want to capture 101, ...
Hi Adam @TheTimeSavingCo ,I am getting stuck at step 4. I have created a new table and linked it to my original table but not sure what formula to put in the new table - what formula am I using in the "Count" field and how do I incorporate the "Sold ...
Hi Adam,When a checkbox is ticked one field, I have another field that creates a number i.e. a unique number sequence for (0-100). I just need that number to now go above 100 e.g. 101, 102. Below my current automation set-up.Would your solution above...
