Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Numerical ranges with child values

Topic Labels: Formulas
468 1
Showing results for 
Search instead for 
Did you mean: 

Here’s an example of what I’m after.

Example Input = “1-4,8,10,15b”
Desired Output = “1,2,3a,3b,3c,4,8,10,15b”

The idea is there’ll be a range between 1-100. Some of these may have children values (example 3a, 3b, 3c). If “3” is inputed it would capture all children. If “3a” is inputed, only that child would be selected. Ideally the ability to indicate a range (1-4).

Any recommendations with this?

1 Reply 1

Welcome to the community, @Cam_Strobel! :grinning_face_with_big_eyes: This isn’t currently possible with Airtable’s built-in search features. The logic you propose requires intelligently parsing numerous options (and sub-options) to pick the relevant items. Custom code using Airtable’s API is the only way I see this being done at the moment. Unfortunately I have zero API experience, so I’ll have to defer to others to take it from here.