LittleMsGinger

Hi @TMCGINN1, You need to wrap the parameter in a single quote. For example '[@Virtual1]'. This way you will be able to use parameter in SQL query. You can also use HTML Block instead. -LittleMsGinger

Hi @Yusuf, I suggest that you review this forum post: I tried this solution on my end and it works!

Hi @Johnn, You can use FormSubmitted event handler. I saw it in the howto article: https://howto.caspio.com/datapages/ajax-loading/ <script type="text/javascript"> document.addEventListener('FormSubmitted', function(event) { alert('Submitted'); }); </script>

Hi @IamBlossom, The type of formula field is equivalent to Text(64000). Text(64000) cannot be used in autocomplete, cascading, etc. Use this formula instead: CONVERT(NVARCHAR(255), [@field:First_name] + ' ' + [@field:Last_name])

Hi @roattw, I tried the solution that was provided by @Vitalikssssss and it works as expected for me. Please make sure that you are using the correct field names.

Hi @taylorswiftlover, Here is a reference that you can use for different math functions available in Caspio: https://howto.caspio.com/function-reference/.

Hi @roattw, Select From (#inserted) table represents data that is being inserted or updated in the table. While Select From (Table), means that you are referring to all the records in the table. Kindly check this link and you will find the information under Additional Notes about Triggered Actions. https://howto.caspio.com/tables-and-views/triggered-actions/ Cheers! -kristina

Hi @roattw, You can use #inserted in the Select From block instead of the Table (Patients_Encounters_Pre121219). If you use the Table itself, every time the Triggered Action runs, it will send an email to all records where Pending_Info is equal to "Y". You can refer to this video for more information: https://www.caspio.com/webinars/send-sms-emails-using-triggered-actions/ Happy Holidays! -kristina

Hello! There is also a way on how to hide a field based on the users membership level. A conditional form is a regular Caspio form with rules consisting of criteria and conditional actions. You can apply conditional rules to create dynamic change forms that fine tune fields based on user entries. In the Rules tab of the DataPage wizard, you can create various conditions to hide, show, require or disable specific fields based on the value or selection of other fields in the same form. You may refer to this link for more information: https://howto.caspio.com/datapages/forms/conditional-forms/ Regards, kristina

Hello! I know it's late but I'd just like to give an update. You can group fields in a form using Sections. Here is an article for more details about it: https://howto.caspio.com/datapages/datapage-components/multi-column-and-sections/ Regards, kristina

Hello @integral, I found a similar post like yours. You may check the solution stated here: -kristina

Hi all, Just to give you an update from the previous comment above, with the Release 19.0, the system increases the size of the file to be imported in Caspio Bridge. In manual Import, from the maximum size of 150 MB, it is now 500 MB. You can check it here: https://howto.caspio.com/release-notes/caspio-bridge-19-0/ Regards, kristina

Hi @Leon13, Are you going to save it in the same table? What I can recommend is to use a separate Table that will contain duplicate records. With your workflow, we are going to use the new feature of Caspio in Triggered Actions. With the recent release, Loops and Variables is now available in Triggered Actions and Tasks. I have here a sample Triggered Action that will insert identical records based on how many quantity a user entered. Hope this helps! -kristina

Hi @bertc, What I understand with your workflow is that, you would like to display the County information to you DataPage also. You can create a View that will join two tables and use this as Data Source. In that case, you will be able to pull up this field on the DataPage. Hope this helps. Regards, kristina

Hi @brassing, It is correct that Free Plan has a limit of 100 emails per month. This refreshes every billing cycle. Means that if you subscribe today 12/04/2019, then, it will refresh on 01/04/2020. Notification Email and Acknowledgement email counts separately. Means that it will count as two if you enable both emails on your Web Form. Hope these information helps you. Regards, kristina