Jump to content
Introducing AI-Powered GPT Connect!

cheonsa

Caspio Evangelist
 View Profile  See their activity

  • Posts

    554

  • Joined

  • Last visited

  • Days Won

    39

cheonsa last won the day on July 30

cheonsa had the most liked content!

3 Followers

About cheonsa

  • Birthday June 8

Recent Profile Visitors

1,618 profile views

cheonsa's Achievements

Community Regular

Community Regular (8/14)

  • Posting Machine Rare
  • Problem Solver Rare
  • Reacting Well Rare
  • Conversation Starter Rare
  • Dedicated Rare

Recent Badges

64

Reputation

11

Community Answers

  1. cheonsa
    Hi @AdminNWRussian, You may try the solution provided here: https://howto.caspio.com/tech-tips-and-articles/customizing-navigation-menu-based-on-user-roles/
  2. cheonsa
    Hi all, I just wanted to share this Trigger setup that will update the Total field on the Parent Table every time a new record is inserted or updated on the Child Table.
  3. cheonsa
    Hi all, I just wanted to share this Trigger setup that will update the Total Allowance field on the Parent Table every time a new record is inserted or updated on the Child Table.
  4. cheonsa
    Hi all, I have found this article from Caspio's Howto page regarding Variables: https://howto.caspio.com/triggered-actions/triggered-action-elements/variables/ Hope this can help
  5. cheonsa
    For more details about Variables and Table Variable, you may refer to this link: https://howto.caspio.com/triggered-actions/triggered-action-elements/variables/
  6. cheonsa
    Hi all, I just wanted to share another solution to display a message if one of the file fields is blank. Instead of using a script, you can use a Calculated Value. Here is the sample formula: CASE WHEN (LEN(CAST([@field:File1] AS NVARCHAR(125))) = 0 OR [@field:File1] IS NULL) OR (LEN(CAST([@field:File2] AS NVARCHAR(125))) = 0 OR [@field:File2] IS NULL) OR (LEN(CAST([@field:File3] AS NVARCHAR(125))) = 0 OR [@field:File3] IS NULL) THEN 'No file attachment in one of the file fields' ELSE '' END Hope this helps.
  7. cheonsa
    Hi all, Just wanted to share with you this formula that checks if the file field contains a value or not. CASE WHEN LEN(CAST([@field:File_] AS NVARCHAR(125))) = 0 OR [@field:File_] IS NULL THEN 'No Photo' ELSE [@field:File_] END Hope this helps.
  8. cheonsa
    Hi all, Just wanted to share with you another solution that works to automatically update the report upon submitting a new record. Instead of deploying the two DataPages in one webpage, you can deploy the Report in the Footer of the Submission Form via iFrame. With this, the page will automatically reload upon submission.
  9. cheonsa
    Hi, This should be added in the Footer of the DataPage. Make sure to disable the HTML editor first before pasting the code. https://howto.caspio.com/datapages/datapage-components/datapage-header-and-footer/
  10. cheonsa
    Hello! You can also set the Comparison type to Next X Days and put 1 in the default value.
  11. cheonsa
    Hi! You can also check this article for different syntax available when displaying parameters: https://howto.caspio.com/parameters/displaying-parameters/
  12. cheonsa
    Hi all, In addition, you may refer to these links: https://howto.caspio.com/triggered-actions/triggered-actions-2/
  13. cheonsa
    Hello! You may also want to check their Howto article on how to change the background color of the results page dynamically: https://howto.caspio.com/tech-tips-and-articles/how-to-dynamically-change-the-background-of-a-results-page/
  14. cheonsa

    Two SUBMIT buttons?

    cheonsa replied to JohnM's question in DataPages

    Hi all, Just wanted to share with you this solution for adding another button that submits the form and redirects to another DataPage.
  15. cheonsa
    Hi all, Just wanted to share with you this solution for adding another button that submits the form and redirects to another DataPage.
×
×
  • Create New...