Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Tubby last won the day on September 13

Tubby had the most liked content!

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Views are like virtual tables, they do not have their own values, they just depend on the values of the tables that they are joining. So if the Views are not updating, it might be that the tables joined together are not updated or only one of those two tables is updated and the join is not made. Hence, not getting into the View. (Because the View did not find the foreign key identifier in the other table). This is, at least, what I understand about Views. Regarding triggered actions, you can update two or more tables. You just need to put all update blocks/actions inside a single triggered action and make sure that there is no Triggered Actions on the other tables that may cascade (well depending on the plan, we can have up to 2 cascading triggers I think) Sharing this article that might help: https://howto.caspio.com/tables-and-views/triggered-actions/#:~:text=to the trigger.-,Combining Actions,-A single Triggered
  2. Hi there, You can try using this JavaScript snippet to add a dollar sign to your cascading text field. <script> document.addEventListener('DataPageReady', function (event) { var src = document.querySelector('[id*=InsertRecordMoney]'); src.onchange = function() { if(src.value.charAt(0) == '$'){ src.value= this.value; } else{ src.value = '$' + this.value; } } }); </script> The if else statement just checks whether the dollar sign is already existing so it would not duplicate it if you happen to change the value of the currency field. This is what it will look like on DataPage startup:
  3. It isn't much of a help but you can check this link to see if there is any downtime or increase in latency on your account's site. http://status.caspio.com/ You can click on the site name and it will show some information about the current performance of the server. Edit: You can check your account site in Account > Account Settings There is also a tweet about an upcoming maintenance. Let's just hope this maintenance helps with the slight performance issues lately.
  4. Hi. You can also just go to "Results Page Options" in you DataPage Wizard and go to the Advanced Tab then check this option:
  5. I think task would do the work for this. If I got it correctly, the only conditions are to check if the user is under any of the three lead groups and if they have submitted their answers for the survey. You can do something like this for the task: This is assuming that it is only a one-time thing. If this is going to be recurring then you might need to tweak this to have another field to base on( like a date field or something else).
  6. Actually, one of the comments from @autonumber's link worked for me. It is a workaround and a bit long to setup but it works just fine. It just basically makes the hours, minutes, seconds, and milliseconds to zero so that it will not show on the table once inserted. Here is a sample if it helps: You may want to try this one if it suits your preference.
  7. Hi, The simplest way I can think of is to create a new table that is chart-able in a sense that it contains numerical results (like the count of each option chosen by your participants) and use Task to insert values to the new table. Here is an sample task that I made based on your screenshot: The new table in this sample is "Chartstbl". This is, however, assuming that you only need the current values for your presentation. If there will be new records to your Survey table in the future, then you may need to create a Triggered Action instead. This is also assuming that there are only 3 choices as seen in your screenshot (a,b, and c). You will need to create another Insert block for each of the questions. Its kind of a hassle to do that but there is a duplicate function when you right-click on the insert block. That might help a bit. This is how the new table looks like after running the task. With this table, you can use QuestionNo as the Category field and the three other columns as the Value fields.
  8. Just want to share another forum post that is similar to this question. I have provided another approach/possible solution there:
  9. Hi there~ The reason why it doesn't allow you to use the formula field as the "Field for value" of the Cascading Elements is because of it's character limit. Since you are concatenating two Text(255) fields in the formula field, the system assumes that you will exceed the character limit of Cascading Elements which is 255 characters. GoodBoy's solution might work for you if you are sure that the two Text(255) fields combined will not exceed 255 characters any time soon. Otherwise, it will cut the exceeding characters in your formula field. A workaround that I have for this that will not remove any characters from the formula field is to create criteria under the formula field and change their form elements to the cascading element of your choice but have them use the two fields that you are concatenating as their "Field for value" so they wont exceed 255 characters. For the first criteria, use the original parent field that you are planning to use. For the second criteria, use the first criteria as the parent field to avoid any filter only records that contain the text on the first criteria. Lastly, change the comparison type to "Contains" to avoid "No records found." message when you are not search for the exact values. Here's a sample screenshot: Hope this helps! ~Tubbs
  10. Hi there, There are two possible reasons as to why the inline insert is disabled for you: 1. You are using a View as the DataPage's data source and it is currently set to be not editable. 2. There is a required field that it not included in the report. Hope this helps! ~Tubbs
  11. I think the virtual field is being rendered as an integer which is causing the output to be rounded off to the nearest whole value. Try this formula to convert the virtual field to a float/number data type first before the calculation: CONVERT(FLOAT, [@cbParamVirtual1]) / 60 You can check this article about the CONVERT function: https://howto.caspio.com/function-reference/#:~:text=Miscellaneous Functions and Expressions
  12. Have you tried checking if there are any formula fields that are using the field? Also just to be sure that all records does not contain a value for this field you can try filtering in the Data Sheet as shown in this screenshot: I hope it helps.
  13. Yes. Failed Datahub import/exports are still counted as Datahub calls. This is because there is still an attempt from Caspio to connect to your server/s. There are no documentations about this but here is an article about Scheduled Tasks (DataHub) Tips and Best Practices that might help with understanding the different Error and Warning Messages: https://howto.caspio.com/tables-and-views/scheduled-import-and-export/scheduled-tasks-datahub/ ~Tubbs
  14. Hi @Joemac, You can create an Integer field for the count and use a Task to update the record count of jobs for each client if you have some sort of Client_ID field for both tables as a reference. I have sample here that you can refer to: I hope this helps! ~Tubss
  15. Hi @Joemac, You may also want to check this HowTo Article about Function Reference for other helpful formulas: https://howto.caspio.com/function-reference/ I hope it helps. ~Tubsss
  • Create New...