Skip to main content

I have a Teams level workspace with the following solution : 

  • Services Rendered
  • Businesses
  • Staff
  • Monthly Reports
  • YTD Reports

The monthly & YTD reports are essentially acting as join tables for generating rollups, counts, and other formula fields to create up-to-date Month & YTD reports each time a new Service Rendered is submitted. In order for this to work smoothly for month reports, I set up an automation to relate the services rendered and businesses they were rendered to directly to the report itself each time a new SR was submitted. In order to add the new SR & Business without overwriting the others, I had to lookup and re-insert ALL the businesses and services each time. Not a big deal for one month’s work. BUT…


Now, I’m ready to create a similar YTD report of my monthly reports table but quickly discovered that we will always have more than 1000 services rendered in a year, so this will not work for the YTD report after the first few months have passed. Is there a way to break it up and insert all the records for the year, even if there are more than 1000? Like, doing multiple find steps and then relating them all? 

Thank you in advance for any guidance!! 

Ugh, never mind, I am so dumb. I am just going to use rollups to generate my annual. Sometimes, you just are making it too hard in your head, right? 🤣

​@Erica_Bass 

Great to hear that you figured it out!

For future reference, if your really do need to perform a find for more than 1,000 records, you have 3 options for that:

  1. You can write your own custom Javascripts to do that.
     
  2. You can perform multiple find actions — each one based on a “view” instead of a “condition”. And then make sure that you have less than 1,000 records on each view.
     
  3. You can use Make’s advanced automations for Airtable, which lets you specify ANY maximum number of records that you would like to return for your search results. If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Reply


Terms & Conditions