Add a better field type for arrays/lists/collections
Right now the list data type can't be used as a true collection. For instance:
What if you have a collection of orders, and each order is for a number of products?
I'd like there to be a field called 'products' in the orders table which would be either a list of strings, or better yet a list of references to a products table.
Instead, you can't add strings unless they were added in Caspio Bridge in advance. Worse, the only way to edit a string list is to check them off from a complete dropdown/listbox of all possible products, which is way to many for users. So Caspio's build in lists don't work for this use case.
Other similar use: Adding users to a group of users, like in an email application when sending emails.
I see this working with an autofill dropdown which adds elements to the list, like in gmail and other mail programs.
It would also be essential that these lists could be usable as lists in triggered actions and tasks.
It would be possible to add this as a way to edit comma delimited strings, as opposed to a whole new data type. That way, it would just be another option alongside dropdown, list and so on.
If this route was taken, in triggered actions and tasks a new block should be added for breaking a comma delimited string into a real list.