Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


Glitch last won the day on November 2 2020

Glitch had the most liked content!


Recent Profile Visitors

833 profile views

Glitch's Achievements

  1. Hello there, This can actually be modified on the localizations now. Easy-Peasy.
  2. Hi there, That's right, PDF Generator is not available on Details DataPages. I tried creating the List DataPage to be able to download PDF too. I tried this article This worked to me before, but for some reasons, it stopped working now. I know that this was already deprecated. So I guess, having the List DataPage is the correct road to go to, though when embedding the document isn't really effective. I tried to create the whole word document so that it would fit to caspio's PDF generator. It's a bit of work though but it pays off, somehow hehe.
  3. Hi there, that's correct. the reason why it's returning an error is if you have 0 on the division. You can just add a NULLIF to your statement. You can use this formula: ([@field:Elig_Reg_Riders]+[@field:Elig_Spec_Need_Riders])/NULLIF(([@field:Regular_Runs]+[@field:SPED_Runs]),0) Let me know if this works.
  4. Hi Taylorswiftloverdover. I am not sure if this would be the most efficient formula, but this works: CONVERT(FLOAT, (Substring([@field:a], 1, 255))) I don't know, it might be silly. So the substring 1, means that it will be the starting point of the new text, then convert it to number. Works for me, but I know there could've been a better formula
  5. ISNULL stills seems to be working for me. If it were true that ISNULL will be deprecated, what should we use as a replacement?
  6. If you want the maximum submission to be just 12, then you can just set the fields inside the QTY field to 12. The inner join you see up there in the select will serve as the loop that while the QTY is greater than or equal to a certain value, then, continue adding the field.
  7. I can't think of any other ways to do this but using Triggered Actions, although it may take a Loooong syntax having the sample email I saw. I was thinking of using case when statements that if the value is blank, then skip the field. Then concatenate them all in the message body. (Not actually a good idea). I'm not also sure if the HTML format can render some javascript and that can be an option too.
  8. Hello Batchini! You can actually modify it on the Formatting of your Checkbox. Go to the results Page, change the formatting to something else. You can create custom Values, and maybe change the color according to your preference. It should look like this: Hope this helps. Glitch();
  9. I had this type of workflow before. My workflow is: When updating the Record, it will not really "Update" the record, but it will need an approval first before the actual record is updated. I don't know if that makes sense But think of it as, getting an approval first before updating the Data. I guess that would work on this type of workflow. It's a very crazy trigger, what is does - is it deletes the #inserted record (with conditions of course) then moves the #inserted to another table. This way, unless the conditions on the delete block is met, it will not consider the record updated. One work around that I could think of, without the trigger is to maybe, just create a submission form below the Reports, so there you can submit the Suggested change. Or maybe just create something like an audit trail like this one:
  10. I think I already asked this before. They had some suggestions, but I don't think that's going to be possible as of the moment. Maybe you can check the last reply.
  11. While Triggered Actions does not work on Import, maybe you can use tasks as a replacement. Tasks work pretty similar with triggers. Their only difference is what fires them. Trigger runs on table modifications (Insert, action, delete), Tasks runs on a scheduled time or on demand.
  12. You just need to add this piece of code inside the block: form[id^="caspioform"] { margin: 0px auto; } That's it. =)
  13. To start with, what type of DataPage are you using? If you're using a Tabular or a Pivot, then you may not need SQL statements anymore since we have a Total and Aggregation function in caspio.
  14. To explain more about this trigger, I implemented this to my app as well. The reason why we need a dummy table is because this will be the static value of until how many days can an event last. If you only set the row up to 30, the maximum days of events will be 30.
  15. Tasks can only run Hourly, Daily, Monthly. For better performance, it is advised that you have a leeway of 15 minutes for every task. in this case, you can only run 4 tasks per hour. So for the task to run every minute, you have to create 4 tasks, just what Maymusic has mentioned. So I think, it's not possible for you to run it every 10minutes. Unless, maybe if you set different timezones, which I have not yet tried.
  • Create New...