Mar 13, 2023 03:54 PM
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 automation beyond 100?
Mar 13, 2023 09:21 PM
Is that "Length of records" value coming from a "Find records" action? If so, that's due to "Find records" only being able to find 100 records at a time
Possible workarounds involve using a script to find the records instead, or modifying your base to show the count, depending on what you're trying to do / comfortable with
Mar 14, 2023 01:35 PM
Thanks @TheTimeSavingCo - how would I go about modifying my base to show the count so it starts capturing numbers above 100? I am not sure how to go about creating a script.
Mar 14, 2023 08:10 PM
What conditions are you using for the "Find record" action? I would create a new table with a linked field, and create a formula that would output based on those conditions and link to the correct record in that new table
The new table would have a "Count" field that would give the length of records. If you could provide screenshots of your tables and relevant fields, as well as the conditions for your find records action perhaps we could come up with something together?
If you're not comfortable with scripting I would advise against it as you would then need to get help every time you wanted to make a change
As an aside, perhaps you could try using a third party solution for this, e.g. Zapier, to do the "Find record" action to see if it returns more than 100 records? Long shot, but if it works it'd save you a bunch of time
Mar 15, 2023 05:45 PM
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 solve for that?
Thanks so much for your help!
Mar 16, 2023 01:42 AM
Yeap it would. I see your "Find Records" action is when "Sold is Checked", so to get the solution to work:
1. Create a new table called "Rollup" or something
2. Create a single record in that table
3. Link all your records from your original table to that single record from the previous step
4. Create a "Count" field in the "Rollup" table, and add the condition "Sold is Checked"
5. Use the field from step 4 in your automation
Mar 19, 2023 06:44 PM
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 is Checked" condition?
Thanks for your help again!
Mar 19, 2023 10:52 PM
Ah there's no formula, we would use a "Count" field with a condition like so:
Mar 21, 2023 05:50 PM
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, 102 and at the moment both records show 102. Any ideas on a way to pull through the count without linking it so it doesn't update in real-time? Thanks!