Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Tubby

  1. 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.
  2. Hi. You can also just go to "Results Page Options" in you DataPage Wizard and go to the Advanced Tab then check this option:
  3. 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).
  4. 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.
  5. 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.
  6. Just want to share another forum post that is similar to this question. I have provided another approach/possible solution there:
  7. 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
  8. 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
  9. 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
  10. 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.
  11. 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
  12. 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
  13. 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
  14. Hi @HexGone! If you can use triggered actions on your account, you can achieve that using a similar triggered action as this: This triggered action will run on an update event(when you update the status), and then check the updated value of the field "type" (in your case, "Status"). Based on the updated value of "type", the trigger will change the email body to the corresponding CASE WHEN statement that it matches and then send it to the email address included in the updated record. I hope this helps. - Tubsss
  15. Hi @DDLiving, You can search for elements with “_mobile” attached to them in Styles to customize the HTML elements when in mobile mode. For most of the elements there are CSS classes with the “_mobile” or “_tablet” suffix, which contain the current settings for tablet and mobile screens: “_mobile” refers to screen width 320px – 567px “_tablet” refers to screen width 568px – 1024px I hope this helps.
  16. Hi @Joemac If I understood your workflow correctly, once a project is added to the project table and it is associated to a client that is existing in the client table, then the yes/no field for the client will be checked. Is that right? Feel free to correct me if I'm wrong. If that is the case then try a similar triggered action as this: This Triggered Action is created in the Project Table and will run once a new project is created. Sample insert: Sample Output in Client Table: I hope this helps.
  17. Hi @kpcollier I have this workaround but I don't think this is the best way to do it. However, it works for all orientations/ formats. Try this in a formula field: replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( replace(replace(replace(replace(replace(replace(replace(replace(replace([@field:text] ,'A',''),'B',''),'C',''),'D',''),'E',''),'F',''),'G',''),'H',''),'I',''),'J','') ,'K',''),'L',''),'M',''),'N',''),'O',''),'P',''),'Q',''),'R',''),'S',''),'T','') ,'U',''),'V',''),'W',''),'X',''),'Y',''),'Z',''),'$',''),',',''),' ','') I just repeatedly wrapped the field in a Replace() so that all possible text inside will be omitted and replaced with nothing. You can add another layer to that if wish to add "-" to the values that needs to be removed. Sample in my application: Table Design: I hope it helps... ~Tubbs
  18. Hi Arthur. I found this in Caspio's HowTo Articles: https://howto.caspio.com/function-reference/ I thought it might help you. Check under "Text Functions". Basically, you will just need "N" before the single quotes that wrap your values in the formula field. For example: This way, your values will be converted to NVARCHAR which allows Unicode characters which most other language characters are. This will not affect your normal English characters. Here is a sample output on the table and on a report datapage: It even works with emoticons/emojis. I hope this helps you. Good luck on your project. ~Tubbs
  19. Hi again Hexy! These are the criteria for the different Password Strength: Fair: Password must be at least 6 characters, including at least 1 number. Good: Password must be at least 8 characters, including at least 1 number and both lower and upper case letters. Strong: Password must be at least 12 characters, including at least 1 number, both lower and upper case letters, and at least 1 special character (e.g. _, #, ?, !) You can actually see this criteria if you test the options out and just put 1-2 letters so an error message will display like shown here: I hope this helps! -Tubbs
  20. Hi @JKSGT, Sorry about my previous message. I think I may have found the ACTUAL solution. What I found is, wrapping your Virtual Fields with single quotes (' ') actually fixes your problem. It gives 12/31/1900 as the result when [@cbParamVirtual2] is null, you don't even need to use ELSE to set it as NULL. Check this formula: CASE WHEN '[@cbParamVirtual2]' IS NOT NULL THEN DateAdd(year, 1,DateAdd(day, -1,CONVERT(DATETIME, '[@cbParamVirtual2]', 103))) END I hope this helps. -Tubbs
  21. I think you can actually use <br> for Calculated Values. However, you will need to enclose it with a single quote. Refer to this syntax: '[@field:Line1]'+'<br>'+'[@field:Line2]' You can also use CHAR(13) which is a SQL Function called "Carriage Return" since Calculated Values accepts SQL statements. Refer to this syntax for CHAR(13): '[@field:Line1]' + CHAR(13) + '[@field:Line2]' This will output the values like shown in the screenshot below: I hope you find this useful.
  22. Hi, I dont have a direct solution for this but I found a workaround if you are trying to achieve the same output as mine. This is what I have: Since I cannot enable data grouping for the ParentID when it is already used for the aggregation and I cannot create a virtual field in tabular reports, I made an addition field in my table and made it a Formula data type. That way I can insert the value of the ParentID to the formula field and use that field in the aggregation instead. Afterwards, I enabled data grouping for the ParentID field and it was automatically ordered by descending the total number of records with the same ParentID field. This will create an extra field on the table though but if you dont mind it then I think it a good workaround for now. If anyone has a better solution for this kindly share it with us.
  • Create New...