MVPofInnovation

Thanks for sharing this information. I got it mostly working but I'm having trouble with the positioning of the picker pop-up. The form field is in the middle of the page and the pop-up is way down to the left. It seems to be positioned relative to the Body, not the element that contains the field. Any suggestions?

Brilliant. Thanks for sharing.

I think the best approach might be a third formula field that combines the formulas used in the first two -- recalculate everything to get the final text you want.

Seems like a good use of Cascading Elements to me. Unless I'm missing something, you don't need Javascript at all. Just build your form with Cascading Elements. This element is build to provide child options based on the option selected in the parent. https://howto.caspio.com/datapages/datapage-components/cascading-elements/

I'm looking to add a similar feature where users can upload a .csv to append a table. I think it can be accomplished with an automated data import/export task. Users upload to a folder using a .csv template, the automated task validates data and appends the table. I haven't tried it yet, but I think that is how it would work.

I'm not sure when this became available, but you can remove the 'Data Table' tooltip in localizations. Results Pages > Labels & Markers > Data Table Tip (Make the 'Custom Text' field blank)

I feel like this should be simple, but I'm stuck. I'm trying to get querystrings to work in a zapier Webhook GET step for a zap to update Caspio via API. Here is the URL: https://xxxxxxx.caspio.com/rest/v2/tables/tbl_contacts/records?q.where=crm_contact_id=338020465 But, in Zapier Builder I have to break up the URL into the base URL with separate queries. It's got one box for the param, and one box for the data. I've tried a bunch of different combinations and still don't get the expected result -- it just keeps returning all records. What goes in the Param box and what goes in the data box? Do I need to add a "?" to the end of the URL?

Thanks @JolliBeng Sometimes it's the simplest things that hang you up. I was searching for "text field wysiwyg html editor" and kept coming up empty.

I got this error after updating a triggered action. The cause was a mismatched data type between the field I wanted to update and the field that contains the data. The thread referenced by RuisiHansamu is basically the same problem, in reverse. They changed the data type of their table field which caused a mismatch in a data type used in their triggered action commands. (The moral to the story here is don't change data type for a field that has any data or dependencies. To make a data type change, best to create a new field and configure relationships, forms and triggers to switch from the old to the new.) If you see this error, it's likely caused by a calculation somewhere.