Hey everyone! I’m working on a front-end ERP project using Softr and Fillout for the interface, with Make and Airtable handling the backend and database stuff. I’m struggling to set up good date range filters. It’s a basic feature, but it’s giving me a headache!
Has anyone tackled this before? What worked for you? I’m open to any clever tricks or workarounds you’ve come up with. Maybe there’s a neat Airtable formula I’m overlooking, or a smart way to use Softr’s built-in features?
I’d really appreciate any tips or examples you can share. Thanks in advance for your help!
I’ve wrestled with date range filtering in Softr-Airtable setups before, and it can be tricky. One approach that worked well for me was using a combination of Airtable formulas and Softr’s filter conditions.
In Airtable, I created two formula fields: ‘FilterStartDate’ and ‘FilterEndDate’. These use the DATEADD() function to create a rolling date range. Then in Softr, I set up filter conditions using these fields.
For more complex scenarios, I’ve found that pre-processing the date ranges in Make (Integromat) before sending them to Airtable can be more flexible. You can create a scenario that takes user input, performs any necessary date calculations, and then updates a ‘DateFilter’ field in Airtable.
It’s not always straightforward, but once you get it working, it’s pretty powerful. Hope this gives you some ideas to explore!
hey mike71, try custom js in softr for date filtering. i built a quick script to capture and reformat user date input and trigger an airtable api call. works like magic in erp projects. dont forget to sanitize user inputs!
I’ve found that leveraging Airtable’s DATETIME_DIFF() function can be quite effective for date range filtering. Create a formula field that calculates the difference between your target date and a user-input reference date. Then, use Softr’s filter conditions to show records where this difference falls within your desired range.
For more granular control, consider setting up a Make scenario that runs on a schedule. It can update a ‘DateStatus’ field in Airtable based on your specific business logic, which Softr can then use for filtering. This approach allows for complex date calculations that might be cumbersome to implement directly in Airtable or Softr.
Remember to thoroughly test your solution with edge cases to ensure reliability across your ERP system.