v8.21

Formulize and AI: connect an AI assistant to Formulize!

Local development: set up Formulize in Docker

Discuss this release in the forum

Changes since 8.20…

For users - people who fill in forms, search lists, view reports, etc

• You can use {element_handle} in searches to refer to the value in another element. ie: to find all entries in a form where the selling price was greater than the buying price, you can use: >{buying_price} as a search term on the selling price column
• When a linked element shows multiple values from the source entry, searches work for any of the values shown (not just the primary source value as before)
• OR searches spread across multiple columns are now more readable by using a colon. ie: in a fruit column and a price column, you could search for OR:apples for fruit and OR:>3 for price to find all entries where the fruit is apples or the price is greater than 3 (previously you did this with no colon)
• In a one-to-many dataset, you can now search for entries on the “one” side that have no corresponding entry in the “many” side. Use EMPTYSET: to do this. ie: in a dataset where each Client has many Bookings, search a bookings timeslot column with EMPTYSET:noon to find all the clients who have no bookings for the noon timeslot (a regular search for “not noon” would not work, because if someone has a noon booking and a 1pm booking, that person would show up in the results thanks to 1pm being “not noon”).

For creators - people who make forms, configure lists and reports, etc

• New filter types for date elements in list screens: Months of the year, and Last 12 months (as dropdowns instead of making users deal with a manual date range filter)
• There is now a Copy button to copy the tool parameters and responses in the embedded AI assistant. Learn more about Formulize and AI
• Fixed a bug affecting the saving of code-based content for static content elements

For app developers - people who build applications, use the API, etc

• Fixed a bug affecting the API keys when re-saving AI settings

And many more little fixes and improvements!