This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi,
I’ve been trying to filter a Rollup field through the API, using the filterByFormula option. It returns a string of numbers, since it uses the ARRAYCOMPACT(values) as the aggregation function. (ex: Product age : [“10,11,12,13,14,15,16,17”] )
I ca...
I’ve updated the table, and changed the Product Age, by using 2 values Min Age, and Max Age, as the date will be a simple range. This way I can get a single date and or a range of dates.
Thanks for all your help! :slightly_smiling_face:
Ok so the Product Age that is fetched from another table is a Multiple Select, so its text (the table was created by someone else, I’m currently trying to create a simple react app that uses the API to help filter the results in a specific way).
Is t...
Thanks that helped a lot!
It’s now returning values, and helped me understand a bit better how the formula works, meanwhile I figured that using FIND it’s not the best approach, since if I try to get results with 8, I will get everything that has an ...
