Hi, I have a simply one that I just can not figure out. I know it's easy but I haven't been able to get this to work.
I have a field where the user will enter a date. I want to take that date and add one, then insert into another field on a submission form.
Field Name: End Date (user entered) = 10/23/2017
Field Name: Expire Date (calculated) = 10/24/2017
Any help would be appreciated.
As of July 12, 2018, Caspio introduced new features which you can find here: https://howto.caspio.com/release-notes/caspio-bridge-13-0/
This release includes a new feature, Calculated Values in Submission Forms. This allows you to generate calculations which you can use for your date using Mathilda's DATEADD(dd, 1, [@field:end_date]) and then submit/insert it to your table without using JS.
Check these videos for more information: