SinJunYoung

Can you give an example workflow? It would be nice if there's screenshots, pictures and diagram of sample workflow that you can send here so we can try to see how we will do it within DataPages display. You can use different functions to achieve that For now, let this link be your guide: https://howto.caspio.com/function-reference/ https://howto.caspio.com/datapages/datapage-components/calculated-values/ https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ Hope this helps

It is also good to see the release notes for you to check out the features that are fixed and added. Here yo go: https://howto.caspio.com/release-notes/

Since altering the formula may be an issue, I would like to suggest creating another formula field and copying the formula from the previous one so it gets you a fresh set of field. I am thinking that the system automatically preserves the alteration of the field to avoid failing and possible incompatibility issues.

Either you set is as checked by default on advanced: or you can also choose to make the field required so that users cannot bypass and check this box:

Hey @taylorswiftlover, Yes, this is possible. On a table level, I have tried them using Triggered actions:

What's your workflow? Using a lot of virtual fields may work but these article regarding parameters may be able to help you as a guide: Parameter Types System Parameters Passing Parameters through Caspio Bridge Displaying Parameters Parameters as Query String Values Receiving Parameters Resetting Parameters Parameters in Dropdowns, Listboxes and Radio Buttons Custom Filter Elements

Since you are starting with Caspio, here's the best practices: https://howto.caspio.com/datapages/best-practices-in-creating-caspio-applications/ (it helped me a lot!)

I am thinking of downloading them in excel and getting them fixed there, it usually does this trick to my case. As long as they have their respective IDs, then they can be easily appended on the table: https://howto.caspio.com/tables-and-views/importing-data/

Oops, they must have had a slight mistake on this, but yes this is doable. I have been struggling with a criteria for some time until I stumbled on this article which is also really helpful: https://howto.caspio.com/faq/reports-datapages/how-to-add-today-to-after-now-or-next-x-days-criteria/

Hi @jazmichaelking, there is a Google ID service setup if you are not aware of with Caspio Auth. Here is the link: https://howto.caspio.com/authentications-and-connections/setting-up-id-services/

Hi @Mitch, If you want to use the 00, then you will need to use prefix autonumber instead of the regular autonumber: Afterwards, create a formula field that will concatenate the records, but, since they are of different DataTypes, you will need conversion to text (preferred than conversion to number or integer). Try this formula: CONVERT(VARCHAR,[@field:Concat_ID_2])+ '-'+ [@field:Name] CONVERT(VARCHAR,[@field:Concat_ID_2])+ '-'+ [@field:Name] - The Bold text here represents the Prefix autonumber, CONVERT(VARCHAR,[@field:Concat_ID_2])+ '-'+ [@field:Name] -

Hi @drmt1979, I do not know much about developers, but there's always Professional Services team that you can consult regarding feasibility and deployment of your application. If you have an account, I believe an Account Manager will be assigned to you and you may contact them regarding this. This is what I can recall as I also had a project with them before.

Yes, Sandy is correct. Double-check on the behavior of the script (it can even be as simple as a simple CSS that may be impacting the behavior of this DataPage to not work as expected). Check if you have eventhandlers affected or accidentally called. Try this: https://howto.caspio.com/datapages/ajax-loading/

What is the current view of your Submission form? It would be nice to make sure that there is a required to fill up by a user to prevent blank submissions.

Hi @TomasJerry, I had the same issue and I contacted support. They told me that "Caspio applications require third-party cookies to be enabled. If you are using a browser with third-party cookies disabled or cross-site tracking prevention enabled, you cannot log in to Caspio applications or may have issues filtering data in reports. In this case, a default Caspio system message will be displayed to notify you of the issue." You will be required to enable cookies in your browser: https://howto.caspio.com/system-requirements/