Jump to content

Glitch

Caspio Guru
  • Content Count

    112
  • Joined

  • Last visited

  • Days Won

    10

Glitch last won the day on August 24

Glitch had the most liked content!

4 Followers

About Glitch

  • Rank
    Advanced Member

Recent Profile Visitors

317 profile views
  1. 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.
  2. 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
  3. ISNULL stills seems to be working for me. If it were true that ISNULL will be deprecated, what should we use as a replacement?
  4. 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.
  5. 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.
  6. 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();
  7. 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:
  8. 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.
  9. 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.
  10. You just need to add this piece of code inside the block: form[id^="caspioform"] { margin: 0px auto; } That's it. =)
  11. 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.
  12. 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.
  13. 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.
  14. Or you can add this line on your CSS> <style> table[class*="cbFormTable"] { border: none !important; background: white; margin: 0px auto !important; } </style> Hope this helps. =)
  15. Hi @Josh1425, You can use this Formula to get the first name: left([@field:Name], charindex(' ', [@field:Name])-1) This on the last name: right([@field:Name], (len([@field:Name])-charindex(' ', [@field:Name]))) Only problem I see here is if the User has Second name, the formula will just get the first part split by the space. And then the Last name will be considered all the string after the first name. I hope this helps. Glitch();
×
×
  • Create New...