Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


ManokNaPula last won the day on September 7 2019

ManokNaPula had the most liked content!

About ManokNaPula

  • Rank
    Advanced Member

Recent Profile Visitors

436 profile views
  1. Haven't tried that one yet, but I believe you need to set up an ID Services as stated on this documentation. On this link, you can follow how to set this up. https://howto.caspio.com/authentications-and-connections/setting-up-id-services/ More about Open ID on this article: https://howto.caspio.com/faq/authentication/what-is-openid/ I hope this helps.
  2. Hi Carioca, Like the previous comment said, File and List DataTypes are not available in triggers, but we do have workarounds. So, since I can not pass the files, what I did was to store the files on the Filestor CDN. From there I was able to get the Full path of the file by first displaying the files on a reports page. The path should look like this: https://eucdn.caspio.com/XXXXXXXX/folder_name/file_name Then using formula field, you can just concatenate the file name, from there, you can now access the files and now, you can also use it inside the trigger. Very
  3. Having to change the style will make all the DataPage using the same style adjust. If you want to apply it on in a specific DataPage, I suggest that you use CSS coding and apply it to your DataPage header. It should look like this. .cbFormTextField{font-size: 16px !important} Hope this helps. hehe
  4. I can't upload it here, i dont know why I have this restriction. I tried, but i can only be allowed to attach a very small file. hmmmmm Maybe I can send message it to you.
  5. Yes, that does make sense. Here's a sample trigger that I created: http://prntscr.com/p2uz6b You need to create 2 triggered actions, one for Insert and another for Update. The reason is because, upon Insert, we only need to compare the inserted with the other values, if it is less than the minimum of the Min Value. But on Update, we need to compare the #inserted if it is less than the previous value and at the same time, compare if it is less than the Min Value inside the Table. Unless we create a separate trigger for the Update, the trigger will still recognize the pre
  6. Hello Batchini! Well, there would be two ways how to create this. If we're going to use trigger, this may be a complex one. One easy way I thought of is with the use of Calculated Fields, but this would only be on a DataPage Level. You can use this formula to get the Minimum Value. SELECT MIN(FieldName) FROM Child WHERE ID = target.[@field:FieldID] Assuming if you have a foreign Key inside your child table. So we'll be using this formula to display the minimum value, Datasource would be your parent table. I hope this helps. Scar();
  7. Hi there, I am creating a ticketing system. I have a same idea as this forum post: So I have three DataPages for just one workflow. I understand that I needed to have these when using standard feature, but I'm a bit short in Number of DataPages. So as much as possible, I would like to lessen it. I have these DataPages. 1) Submission Form - where the tickets are being submitted. 2) For Assigning ticket (This will receive a timestamp which will indicate the Start Time for the ticket) 3) For Closing Ticket (Receives timestamp for closing the ticket)
  8. Hi @Glitch This was in the Caspio documentation. You can use up to 16 tables, but best performance should be less than that. ❤️
  9. 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
  10. 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.
  11. You can check out this Article: https://howto.caspio.com/files-and-images/resize-images/ Same function as this one. Hope this helps =)
  12. 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, j
  13. 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
  14. 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
  15. 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 b
  • Create New...