Jump to content

BaySunshine

Members
  • Content count

    22
  • Joined

  • Last visited

  • Days Won

    1

BaySunshine last won the day on June 6

BaySunshine had the most liked content!

About BaySunshine

  • Rank
    Member

Recent Profile Visitors

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

  1. 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.
  2. 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,
  3. 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,
  4. 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.
  5. 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.
  6. 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,
  7. 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.
  8. 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,
  9. 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,
  10. 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.
  11. 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.
  12. Hello humidor, Yes, you can do this by following the steps below: 1. Make the formula field as 'display only'. 2. Add a virtual field of checkbox type. 3. Use 'Rules' to hide the separate field based on the value of a checkbox. 4. If the user chooses to change the date, they enable the checkbox and the separate field shows up. 5. User can enter the data and hit 'Submit'. Hope this helps. Regards,
  13. BaySunshine

    Triggered Action to join 3 tables.

    Hi Magnum, The value 'true' for MngrNotesChk may not be inserted as the light pink true field is just like a placeholder. Click on the Logic or Data button on the left and drag a 'true' field and place it in here. It should then work. Apart from this, I don't see any other issue with the trigger. A full screenshot of the trigger will help us in reviewing it better. Regards,
  14. BaySunshine

    the width of column

    Hello, Can you please provide more details on your question? What is the type of DataPage you used? Have you created those columns using custom code in your DataPage or using tools in your webpage? A screenshot of the issue will be helpful as well. Regards,
  15. BaySunshine

    Auto update table field.

    Hello, This cannot be done automatically due to system limitations in Caspio. It is only possible if you manually run a Report DataPage. Formula fields/triggers need an insert/update to happen to the table to automatically change the status of the field. Hope that helps.
×