Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by LittleMsGinger

  1. Hi all, Just to update you, Caspio has an article on how to hide multiple login screens. Here is the link: https://howto.caspio.com/authentications-and-connections/authentication/hiding-multiple-login-forms/
  2. Hi all, I just saw the new release of Caspio regarding responsive DataPages. Now, you don't have to add line of codes to make your form mobile responsive. You just need to check the checkbox to make it responsive. https://howto.caspio.com/datapages/responsive-datapages/
  3. Hi @rush360, You can actually place these HTML blocks in another section. Then, add a rule that if the field is blank, then hide this section. Cheers!
  4. Hi @Leon13, You may remove the open and close symbol "<>" and insert "&nbsp;" instead.
  5. Hi @IamBlossom, What you can do about this is to add the "," before the result. You may try this one: SELECT ABC = STUFF((SELECT ', ' + CAST(Name AS nvarchar) FROM PE_USER_TABLE WHERE PE_ID = target.[@field:PE_ID] FOR XML PATH ('')), 1, 1, '') I am also using the same formula and I am getting my desired output. Cheers!
  6. Hi @roattw, If you select a field in the table, Custom option will not be available. It is present in Totals and Aggregation if you click on the plus button. Also, picker button is not available in Pivot Table.
  7. Hi @roattw, Actually, you can use Pivot table to achieve your desired Report. You can use Totals and Aggregation under values and add custom formula. This will be the result Cheers! -LittleMsGinger
  8. Hi @LIU123, Your workflow might need Do While Loops in Triggered Actions. Triggered Actions allow data manipulation, calculations and sending notifications by constructing application logic with a visual interface. They will be executed on specified events to perform actions on data in your tables. Changes in one table can affect data in other tables. You may try the suggested solution here.
  9. 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
  10. Hi @Yusuf, I suggest that you review this forum post: I tried this solution on my end and it works!
  11. 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>
  12. 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])
  13. 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.
  14. Hi @taylorswiftlover, Here is a reference that you can use for different math functions available in Caspio: https://howto.caspio.com/function-reference/.
  15. 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
  16. 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
  17. 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
  18. 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
  19. Hello @integral, I found a similar post like yours. You may check the solution stated here: -kristina
  20. 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
  21. 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
  22. 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
  23. 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
  24. Hi @Sherif, If you logged out from one of your DataPages, you will be automatically logged out from the other DataPage. What I can suggest it deploy your DataPages in own hosting site, then, have a custom Logout button, and use the logout link form your Authentication. You may refer to these tutorials: https://howto.caspio.com/authentications-and-connections/authentication/logout-link/ Hope this helps. Cheers! -kristina
  25. Hi @Sherif, Could you please elaborate your desired workflow? Initially, as I understand, you need to calculate the time in hours between the current and previous record with the same ID. Would you like to save it on your Table or just display it in a reports? You may refer to this article for reference in your Formula: https://howto.caspio.com/function-reference/ Regards, kristina
  • Create New...