TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Limit Array size
Hello all,

I was hoping someone might have a solution to this problem:
A Parent record has 700+ child records...this, by the way is constructed from 3700+ possible child records but is slimmed down with filter flags.

I've created a JSON Array formula in the child record which I then concatenate to a larger array in the Parent record.
I have a call URL action which sends to SendGrid....
I need to be able to only send, say 100 (or so) at any time.
However, I cannot neatly find/construct a match filter to parse only top 100.

Setting the view to only show 100 does not have any bearing on this.

Has anyone had any success with this type of arrangement before?
Best regards
Brett
ID
2124
Category
Integration/API
Author

basenine
Date Created
9/18/2025 6:30:25 AM
Date Updated
9/18/2025 4:54:01 PM
Comments
Pierre 9/18/2025 7:40:06 AM
Could you include some numbering in the concatenation, for instance as the start of the line
#00001#...
#00002#...
And then limit your extraction with Left / NotLeft functions ?
(with 700 records you would have to do it 7 times)
cooper collier  9/18/2025 12:24:23 PM
A similar thought to Pierre but instead of numbering add a Date Sent.
Then filter to only include records sent before today.
You can then do batches until the number of records ends up zero.

Then if you wanted to run the same thing next week and the following etc.



basenine 9/18/2025 4:54:01 PM
Thank you guys.

I’ll investigate the left/not left approach a little closer.

I’ve got a mechanism in place for when they’re sent and they drop off the list nicely.
It’s the ones that haven’t been sent I need to batch.
I guess thinking about it from your suggestions :
I could go through the entire list and assign 100 at a time the same (uniquish) identifier (a simple number, perhaps)
Then I add that as a filter flags match condition too. That’ll work…

I appreciate your suggestions…they’ve led me to the solution 👍

Feedback
Back to Search Results