Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


Scarlet last won the day on January 8

Scarlet had the most liked content!

1 Follower

About Scarlet

  • Rank
    Advanced Member

Recent Profile Visitors

147 profile views
  1. Hi @Glitch This was in the Caspio documentation. You can use up to 16 tables, but best performance should be less than that. ❤️
  2. Hi @Glitch, This error occurs when you exceed the limit of 2 cascading triggers. Caspio's cascading triggers is only limited to 2. Now, what are cascading triggers? This is when, a triggers action activates another trigger. So for example, Table A has trigger 1 > The trigger is to Update Table B. Table B has trigger 2 > Trigger 2 runs on UPDATE, then again activates another trigger. Now these are cascading triggers. These acts as a waterfall trigger. I think this error may also happen when you are trying to create triggers on the same event. Say, the events are - Insert records to table1 upon Insert on table2 . And you have another trigger that would insert records to Table2 as well. You can view the triggers associated on the Table by clicking Properties under the Tablename. From there, you can check which of the Triggers are causing the conflict. Hope this helps!
  3. Scarlet

    Time Check

    Not quite good in Javascripts but you can use this one I tried. Create an HTML Block and disable HTML Editor. And then paste this code: <input type="button" value="Time Check" onclick="getElementById('timecheck').innerHTML=Date()"></button> <p id="timecheck"></p> Let me know if this helps.
  4. You can check out this Article: https://howto.caspio.com/files-and-images/resize-images/ Same function as this one. Hope this helps =)
  5. Hi Vanellope! I think this would still be doable within the use of Conditional Forms. You can create a Virtual Calculated Field for the formula, and then use it later on to the Rules. 1st step: Virtual field - Calculated Value. (field1+field2) 2nd Step: Use the Virtual field to compare Values RULE: VirtualField = 50 ACTION: Hide field3. Not quite sure as well if you can use CSS or Javascript inside the CASE WHEN Statement as, I have not tried it yet. Although, this would be a good workaround. If you want to hide the Virtual Fields, you can do so, just visit this link. Regards, Scarlet
  6. They do have documentations regarding this inquiry. You can check out the following links to learn more: https://howto.caspio.com/localizations/modifying-a-localization-object/ https://howto.caspio.com/localizations/ https://howto.caspio.com/localizations/modifying-a-localization-object/ That's all folks
  7. Scarlet

    Form question

    For the second question, "the ability to update one record from from a value in another record. " I think, the Triggered Actions can do the trick. Check out this documentation about triggered actions: https://howto.caspio.com/tables-and-views/triggered-actions/ Hope this helps
  8. Hi there! This is pretty much doable within Caspio. The good thing about Caspio is you have several references and resources which can help you make your own app. On the other hand, Caspio has Professional Service Team if you want them to do the app for you. But regarding your application, Here's my insight. You will need a submission form to create your Booking System. Regarding Start and End Dates, this is also possible in Caspio. The do have Calendar forms that you can utilize to view the record of the schedules they submitted. Regarding the Home Stay Database, it will be like the same as the Booking System. Have you seen the Caspio's Ready Made Apps yet? You can check it out to see what Caspio can do: https://www.caspio.com/apps/ You can check out the Real-Estate App with regards to the Number of rooms or details of rooms you wanted to do. It seems that you have a very specific workflow, which is a good start if you want to create a new app. Caspio is a good choice! Have a great day!
  9. I need to get this working as well.
  10. Scarlet

    Check date

    I think we should use the GetUTCDate() to compute for the difference of the Date to Today's Date? I guess the formula should go like this instead. Datediff(day,GetUTCDate(),[@field:Laatste_visuele_test]) We have this documentation in this link: https://howto.caspio.com/function-reference/ But as I checked, GetUTCDate() is not applicable in the Formula DataType inside your table. Have a great day! -Titania
  11. Hi there. I think the thing that you are missing is the foreign key. A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table. Say in your case, you wanted to create a relationship from tblTrailer to tblWashInfo, you need to have a foreign key of the field ID to the other table. In addition, you may want to check out these links to quickly understand table relationships. 1. Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik 2. One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA 3. Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU Also, if you want to change the display value, you can do so within the Table Relationships. You simply need to change this: http://prntscr.com/mdyjfj Hope this helps!
  12. Scarlet


    Hey there. This is absolutely doable within Caspio. You need to set up the field as currency. On your Reports DataPage, you can set it up to the formatting you want it to. Please check out the following screen shot on how to do this: http://prntscr.com/mdy6v7 http://prntscr.com/mdy7f6 This method will work if the form element is set to "Display Only". Hope this helps!
  13. Hey there, I believe you have a similar function like this inquiry. Click this LINK to see the forum conversation. Hope this helps!
  14. Hey there! Just to add to the previous comment. You can check out this link to learn more: https://howto.caspio.com/tech-tips-and-articles/common-customizations/stamp-the-time-url-or-ip-address-to-new-and-updated-records/ Hope this helps!
  15. Hi there! I think what you need to do here is to setup a Task that will run every day. This is now possible without the use of custom coding. Setting up the Task would be like this: And the logic would be something like this: You can check out this link for more reference about Scheduled Tasks: https://howto.caspio.com/tasks/ Have a great day!
  • Create New...