Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Shiro

  1. Any ideas for a workaround if my trigger needs to work on more than 10,000 records? As I check, we cant use the same workaround for the task, so... ?
  2. @NiceDuck or create a formula field and use this formula instead: CONVERT(VARCHAR(8),convert(datetime,[@field:EmailSent],101),114)
  3. You do realize that you can also just use the same formula for the time values to make them 00, right?
  4. I agree, @NiceDuck, However, you must set the extra table as read only. DO NOT ALLOW any applications to change/update records from extra table as it will cause chaos on the data integrity.
  5. I suggest that instead of using a calculated field, create an extra field on your table and use triggered actions to perform the calculation for you. Since it is a normal field, you should be able to group your values from it.
  6. I just noticed that one of our logout links is redirecting our users to Caspio Homepage (https://www.caspio.com/) when logging out instead of our designated logout page. Any Ideas?
  7. I just got a word from support that Task can only process up to 10,000 number of records only. Is there some we can still run the task if you have more than 10,000 records?
  8. Hello, Anybody has an idea why the Join types on my table relationship is greyed out? I cant change the Join Type...
  9. Hmmmm... I tried that too, however the combined chat and report is actually just a single datapage. Kinda like the extra details page when you enable the details page option. But still, they are still the same data. If you want the other chart or the table to contain different information than the other, you will really have to create another one.
  10. Yes @NiceDuck, they are indeed being ran at the same time. However, it was mentioned there that the other task should be Qued and shall be ran after the others. Mine is not running even though I try to run it manuallly.
  11. I have a scheduled import on my Dropbox account. As I checked, 4 out of 7 of them is not being ran. Any Ideas?
  12. I just want to share this. If you ever need to prevent your triggered action/ task on sending emails/sms on certain numbers. You can create a table which contains all those unwanted email addresses/ phone number and create a blocklist. It is just an extra condition on the where statement if you used a 'select from' block. Hope it helps...
  13. It is possible to submit an email to multiple addresses, that are just on different fields of the same record? ex. On your record, you have 2 fields containing different email, lets name it field 'Email_primary' and 'Email_secondary'. Would it be possible to send email on both of those fields with only one email block?
  14. Shiro


    Cool, Would it be possible to send those Barcode Via Email? Also, would it be readable by the barcode readers?
  15. Shiro


    Is it possible to generate a Barcode on Caspio? How about QR code?
  16. Whats the timestamp for?
  17. Is there some way I can prevent the submission if none of my field is equal to specified value? I have three fields on my submission form. I want the submission form to only activate if at least one of them is equal to yes.
  18. Is there someway I can design a trigger so when I Import a records to my table, it will only import those records which have an actual value. When I try to update some records on my table via import, it overwrites everything even though some of the records imported are blank. I made a trigger that shall only update records which are not null via condition statement but it seems not working.
  19. Thanks @NiceDuck, the passing parameter worked. Im not using the JS for this since I am also not adept on it. If it aint much, may I also ask if there is a possible way I can count the number of times the record is been downloaded? That would also be helpful
  20. Thank you @NiceDuck, However, when I redirect my user to the duplicate search and report datapages, they have to search again for the data they want. Is it possible to automatically set the search of it to be automatically same as before the user click the first download?
  21. Hello Is there a way where I can make my users submit my email first before they can download files or reports from my datapages? ThankYou.
  22. Hi NiceDuck, It's seems like a nice Workflow. However, as I see it, you are also using the work order table as the lookup table for this workflow. Also, those new work orders which is actually a clone of an old record will also be considered as a new record. Therefore, in the Long run, I think this will cause a stress on your data traffic specially when the Work_order table becomes heavily populated. You may not notice that now, but when your records starts to reach hundreds or thousands, The dropdown button that you assigned to look for previous may cause a huge data spike. .... hope that helps
  23. Hi NiceDuck, I just want to ask, are you sure that it is the trigger is the one that is detecting which user made the actions? I think it was the data-page which is able to detect the current user via user authentication. In regards to the delete function. It will just remove the selected record so it even though you have a field which captures the user id of the user, it wont update your records. I think on Delete triggers will only capture the deleted records,
  24. That workflow looks "Nice"Duck hahaha however, I'm only on explore plan so triggers are not available to me. Thank you though
  • Create New...