Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


BaySunshine last won the day on June 6

BaySunshine had the most liked content!

About BaySunshine

  • Rank

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. BaySunshine

    Save Virtual in a Table

    Hi @NJConrcs, You can try the instructions from this article except that replace virtual field with a real field from the table since virtual fields do not store values in a table: https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/ Hope that helps. Regards,
  2. Hi @Perzival, The solution for this question has been already answered in Regards,
  3. Hi @jardenblack26, Try adding '!important' at the end of your code. For example, width=10px !important. Here is a link for info on this rule: https://css-tricks.com/when-using-important-is-the-right-choice/ Regards,
  4. BaySunshine

    Change End Dates

    Hi @Scott, In the Email block, change the table name from ABGCMembershipCoporate to Inserted. For the update trigger, change one of the fields in Inner Join to RenewalsTable.MemertsiopGUID. Right now it is joining only on its own record. So, the update will happen always whether or not it matches with GUID field from RenewalsTable or not. I hope this helps. Regards,
  5. BaySunshine

    Add icons to form fields

    Hi @scottknz, A simple way to show an icon is to save the email image on your web server. In the form, use an HTML block and click on the image button and add the URL of your email image. Specify the height, width etc. In the Advanced tab, select 'continue element on the same line' option. Hope that helps. Regards.
  6. BaySunshine

    Triggered Action just with last update

    Hi @rrodask, To resolve this issue, try select 'inserted' table from the list instead of 'tbl_r1_ronda_quala'. Hope that helps. Regards,
  7. BaySunshine

    Table Date Format

    Hi @Mtasc, @NealPatil, @edujobs2k18, Caspio displays the date values in the table in only US format. The localization option only applies to DataPages. So, you can download the data from a Report DataPage to view the output in your chosen format. Hope that helps. Regards,
  8. BaySunshine

    Triggered Action to join 3 tables.

    Hi @Magnum, Please verify the following: 1) Is the join Notes_Log.UserId = User_Auth.Email correct? 2) Are Notes_Log.ClaimNumber and User_Auth.Email both unique fields in their tables? If the above are right, there doesn't seem to be any error with the trigger. Please provide a screenshot of the table designs of both tables so we can test. Regards.
  9. Hi @NeoInJS, Another way to do this without using JavaScript is by using triggers. If you do not have triggers in your plan, please ignore this idea. First in the submission form, create a Rule which hides the Permanent Address field. If the checkbox is checked, then show it and the user enters the address. If not, it will be hidden. If the checkbox field is not checked, the trigger will execute. Create a trigger on this table which will update the inserted record with "Permanent Address = Present Address" only when the checkbox is checked. Hope this helps. Regards.
  10. BaySunshine

    Hide Form Field Based On Number of Table Records

    Hello @RJOHNSON, There is a way to do this using standard features. Here are the steps: 1. Add an Autonumber field to your table. 2. In the submission form, add a Virtual field. Make sure you create this field under a separate Section. 3. Set its form element to 'Calculated Value'. 4. Enter a formula for the field: select top 1 fieldname from tablename order by id desc Replace fieldname and tablename with the respectives names from your table. 5. Click on Rules and create two rules as below: RULE 1: Under criteria, select the virtual field and operator as 'Is Not Blank'. Under Actions, select Action as 'Hide' and choose the section this Virtual field falls under. This will make sure that the Virtual field value is hidden. RULE 2: Under criteria, select the virtual field and operator as 'Greater than or Equal', and Value as 200 or your desired number. Under Actions, select Action as 'Disable' or 'Hide' as per your requirement and choose the field name that you want to disable. The only downside of this idea is that the virtual number spins while it is still calculating the value. But after that everything works as expected. Hope this helps. Regards,
  11. BaySunshine

    Change End Dates

    Hello Scott, This can be done by an update trigger followed by an email trigger on that table. Please attach an image of your trigger so we can see where the issue is. Thanks.
  12. BaySunshine

    Convert Scientific Notation to Numeric

    Hello @directrix, The formula worked for me. What is the datatype of your fields? I have D_Date as Date/Time, D_Serial as Number, D_Text as Text. The error can be caused by the data that you entered as well. Provide us sample data that you entered and I will try to reproduce the issue. Regards,
  13. BaySunshine

    Expressions in Triggers

    Hello RBobowski, Expressions can be used in Select statement the way you did. You could also use 'Equal' or any other comparison operator instead of 'Exists' and compare the value with the aggregate calculated in the Select statement. Triggers do not allow usage of variables in Caspio like we do in any other programming language. You can have an alias for a field in the Select statement and use that alias in other parts of the same query such as in Where, Group By etc but cannot use it in other trigger actions such as insert, update or delete. Hope this helps. Regards,
  14. The fields in the Details page are addressed as 'EditRecordFIELDNAME' with field name being the actual name of the field as it is in the table. Please refer to this article for help on how to address different Caspio form elements in JavaScript code. By just changing the field name as per the above format in the code from the other forum article should get you the desired results. I hope this helps.
  15. BaySunshine

    Convert Scientific Notation to Numeric

    Is one of those fields a formula field by itself? To troubleshoot the error, I suggest you to try one case...when at a time. Make a duplicate of your table or add a test record to your existing table and test it out. This way you can narrow down to see which particular field/condition is causing this error. I hope that helps.