-
Posts
114 -
Joined
-
Last visited
-
Days Won
13
Glitch last won the day on September 12 2022
Glitch had the most liked content!
Recent Profile Visitors
1,129 profile views
Glitch's Achievements
-
bookish reacted to an answer to a question: Files in trigger
-
GrumpyRick reacted to an answer to a question: Mass Mailing to Users
-
KG360 reacted to an answer to a question: Formula Error
-
ColBasicuser reacted to an answer to a question: Creating Audit Trail via Triggered Actions
-
Glitch reacted to a post in a topic: How Can I Format A Text Field As A Dollar?
-
DefinitelyNot31337 reacted to an answer to a question: Triggered email when field changes
-
Remove "Data Table" tooltip
Glitch replied to dspolyglot's topic in User JavaScript and CSS Discussions
- 17 replies
-
- javascript
- tooltip
-
(and 2 more)
Tagged with:
-
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.
-
DefinitelyNot31337 reacted to an answer to a question: Formula Error
-
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.
-
Syvill reacted to a post in a topic: Multiple submission base on user input
-
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
-
ISNULL stills seems to be working for me. If it were true that ISNULL will be deprecated, what should we use as a replacement?
-
Multiple submission base on user input
Glitch replied to Syvill's topic in User JavaScript and CSS Discussions
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. -
Glitch reacted to an answer to a question: Multi Select Listbox
-
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.
-
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();
-
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:
-
taylorswiftlover reacted to an answer to a question: Centered Report Search
-
Task to send email with multiple records
Glitch replied to matstein's question in Tables, Views and Relationships
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. -
Triggered actions on import
Glitch replied to janetflorence's question in Tables, Views and Relationships
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. -
You just need to add this piece of code inside the block: form[id^="caspioform"] { margin: 0px auto; } That's it. =)
-
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.
-
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.
-
Triggered action to delete records older than 10 minutes
Glitch replied to johnv's question in Tables, Views and Relationships
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.