Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by NiceDuck

  1. That? I just happened to need the same information a while back so I asked my account manager. They also mentioned that the reason why there is a daily limit for email sending is because it is a fail-safe just incase that a user misconfigured his task or triggered action and make it send automatic emails, infinite times which may cause server issues and exhaustion of the accounts resources.
  2. Yes it was. You could also try using emails instead. Here are the pros and cons: SMS: PRos: Much faster (I think) Cons: Canada and America numbers only Emails Pros: Global and no need for extra device. cons: Due to the recent issue, your email may ended up bouncing back or filtered out as spam if you have not configure it correctly. Also, slower to receive (personal opinion)
  3. By default, the daily limit for emails on your account (notification, acknowledgement,trigger or task) is 250. However, if you would contact the support, they will increase that for you...
  4. By the way, I think you can make a huge shortcut on the work if you can make a JS code that willl automate the process on the step 8 and 9. Also, this is for document types of file only. Videos and Such are not applicable. You will have to use a different code which I do not have right now
  5. Hello. I just want to share a workflow again. I made a workflow where your users can view a document type of files, directly on your report datapage. Yes, I know that there is a howto article for that already. its this one: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/tech-tip-embed-documents-in-datapages/ However, the catch on the work I made is, 1) It also shows the download link for the file. 2) The files are stored on your Caspio Bridge account 3) No need for filestore The instruction are on the embeded doc file: display docs on datapage.docx Hope it helps anyone: Quack
  6. just sharing, no problems here
  7. Hello, I just want to share this with you. Yesterday, I did have a submission form that has a special text field whose value is equal to a a bit complicated concatenation of two other fields . Since Triggered action is my personal favorite feature, I used a triggered action to do this concatenation, and the datapage is working as expected. Later on, one of co-user thought that it is wasteful to use triggered action for only this operation. Therefore, he went to the table design and change the data type of this special field to "Formula field". After composing the right formula, he went on his merry way without checking the datapage. Later on, one of the users noticed that they are no longer able to send any data with the submission form because any attempts are ending up with a "Data Restriction" error. After few hours of troubleshooting and some squawking around. We figured out that the reason of the issue is that the triggered action is not updated nor disbaled. What actually happen is, the triggered action is trying to change the value of the the special field. However, since formula fields can create their own value unlike its former data type which is just a text255. Now, since the trigger is failing to run, the datapage is having the error which down the page for about an hour. The lesson is, make sure that if you check if there are triggered action or task connected to field before modifying its data type as it seems that the trigger action is not being updated when you modify the field type. I hope this helps quack
  8. Hmmmmm.... How long does one task takes before completion? I think that they are indeed being qued, however if they are still not run after a certain amount of time (probably 15 mins), they will be skipped. so you may want to keep on check to your other task if they are still running. You may also want to adjust the ran time of the others and check the message tab on your Caspio Bridge Account.
  9. Well, may I ask if all of those scheduled import are being ran at the same time? Caspio allows only up tp 3 Task running at the same time. You may refer to this article: https://howto.caspio.com/tables-and-views/scheduled-import-and-export/scheduled-tasks-datahub/
  10. If you only have small amount of records, it is easier to remove those unwanted addresses. However, as your record grows vast, it will start become troublesome locating and deleting those unwanted addresses. This workflow will surely be helpful.
  11. Yes, you just have to concatenate with a semicolon in between. Kinda like this one: This one is on task, but I am sure you can easily have it converted to trigger.
  12. NiceDuck


    I'm not adept when it comes to CSS and styling so I dont know if it can be done with the email. However, what I'll do is I'm gonna send them an email with a URL to a datapage downloadable as PDF. That datapage has the details and the barcode. I'm not sure if its readable by the barcode readers, I dont have one here But I highly hope so.
  13. NiceDuck


    As for the QR code, I don't know. Their PS team can probably do it.
  14. NiceDuck


    Hello Caspio can use fonts on google web fonts for their datapages. They have a barcode font there which you can use to convert values to a barcode. You may like to check the following URL's for more details https://howto.caspio.com/styles/using-google-web-fonts/ https://fonts.google.com/specimen/Libre+Barcode+39 hope it helps, quack
  15. probably some cookie or cache issue. Try clearing it up, using another browser or even other device. If issue persisted, contact the support.
  16. You may also want to try this one Quack
  17. Hello, are you really on a submission form? As I check, you can only have Calculated values on a submission form and they real time responsive. As for the calculated fields, I think they perform their calculation during on load and if you refer a field from it, it will gather those information directly from the table datasource thus it will not response/change value unless the changed values on the fields are saved on the tables first. You may want to try calculated values. You can set a field to became a calculated value on its form element. I hope it helps
  18. Just an update. As for the workflow I provided above, you are not collecting the values that are being used for searching since we are only using a dummy submission form filled with virtual fields. However, if would also be nice if we will collect those values so we can generate later what are the most search records on your reports. Anyway, if you happened to collect them, you can simply turn the field you are using on the step#5 to "Required" then use this formula instead. Case when [@field:payer] = 1 then *URL of your report datapage plust the other fields as a parameter* when [@virtual1] < 3 then *URL of your report datapage plus the other fields as a parameter* end. for this case, if all conditions is falls, the field will remain as blank. however, since it is a unique field. it will not accept blank values this is will prevent submission. You'll just have to change the error message on the localization. hope it helps, quack
  19. You may also want to refer on this another forum post.
  20. The timestamp is for making sure that the values will be submitted will never be similar to those previously submitted records. You may want to add some strings to it which is relevant to the Data you are submitting. You may refer to this one: CONVERT(VARCHAR(10), SysUTCDateTime()) + 'test' Quack
  21. Hello Shiro, For this case, what I suggest is create another field on your data source table (preferably text 255) and check the unique checkbox. Then on your submission form, set it to calculated value and make an SQL statement like this: Case When '[field:aaa]' = 'yes' then SysUTCDateTime() When '[field:bbb]' = 'yes' then SysUTCDateTime() When '[field:ccc]' = 'yes' then SysUTCDateTime() end BAsically, what it does is it checks all the mentioned fields. if none of them is equal to 'yes', the value of this field will be null. However, since blank values are unacceptable on unique fields, it will prevent the submission. You just have to change the error message on the localization Hope it helps Quack
  22. You may also mix that workflow with this one for overall cover:
  23. hmmmmm I guess you can use a calculated field/value then use conditional statement. put them on the same line with the dropdown by checking the "Place next element on the same line". As for the dropdown, set it to "No label" With that, the calculated field/value will be your label. Again, its just a suggestion. quack
  24. This is how I did it by a triggered action. Note, with this workflow, you would be able to keep the previous value of a field, it will not save the value of newly inserted record. first, duplicate the table which you want to have a history record. go to its table design and change its ID field to a text 255 and rename it "parent_id" or any name you want. Your call, as long as it indicates that it is the records former ID. also, make sure that this field is not set to unique. Add an Id field and name it "History_Id" this will be the records actual ID on its current table. this is not actually a necessity but just for... best practices I guess. Now, on your main table, create a triggered action that will copy the previous value of the updated fields to the history field. You may refer to this picture: There you have it. That is only the basics though. As mentioned above, you may also want to create a timestamp field to record when a value is updated or transferred on the history field. If you have authentication, it will also helpful if you will have a dedicated field for capturing the ID of the user who made the changes. Hope it helps, Quack
  25. Halo, I know that you mentioned "simple" on the post but you may want to check this post also if you want to create a log for knowing who deleted what : I hope this helps quack
  • Create New...