Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. Yesterday
  3. Hi @NeoInJS, You may try pasting the code snippet provided in an HTML Block. (Note: Disable the HTML Editor from the Advanced tab, and move the HTML Block to the very bottom). Note that we can add/remove items in the fields array. We can add DataSource fields as well. Just duplicate field lines as needed and put cbParamVirtualn, or the name of your DataSource field. <script> var fields = [ 'cbParamVirtual1', 'cbParamVirtual2', 'cbParamVirtual3', 'cbParamVirtual4', ]; /* * * Do not modify code from beyond this point */ fields = fields.map( function(elem) { return document.querySelector('[action*="[@cbAppKey]"] [id*='+ elem + ']'); }); function changer(ev) { fields.forEach(function(field) { if (ev.target.value != '' && ev.target != field) field.value = ''; }); } fields.forEach(function(fff) { fff.addEventListener('change', changer); }); </script> [src="carl.js"]
  4. I agree that a feature like this is really a must-have for the platform. Meanwhile, for everyone's appreciation, we may also utilize Pivot Tables for the meantime. Add your distinct-to-be field in the Row, and your date for Values. Then set the summary to Max Do note, however, that Pivot Tables' performance becomes terrible as the DataSource grows. Less that 10,000 should work fine.
  5. The real answer is Caspio should just create a distinct field button of some sort like they do in dropdowns when you can check Distinct Options and Im sure it would take them 20 minutes to do and everyone could use this!
  6. Hi - I have 4 Virtual fields in my submission form and ALL virtual fields have Dropdown form elements. When I select a value in one virtual field, I would like to set the other fields to have blank values. So my scenarios, 1. I chose a value(non-null) in cbParamVirtual1, the values in cbParamVirtual2, cbParamVirtual3, and cbParamVirtual4 would be blank or null. 2. I chose a value(non-null) in cbParamVirtual2, the values in cbParamVirtual1, cbParamVirtual3, and cbParamVirtual4 would be blank or null. 3. I chose a value(non-null) in cbParamVirtual3, the values in cbParamVirtual1, cbParamVirtual2, and cbParamVirtual4 would be blank or null. 4. I chose a value(non-null) in cbParamVirtual4, the values in cbParamVirtual1, cbParamVirtual2, and cbParamVirtual3 would be blank or null. I hope that this would be a simple JavaScript that you can provide. Thank you for the help.
  7. Last week
  8. Hi, just to update this post. Here is the new and updated link of creating conditional forms with rules: https://howto.caspio.com/datapages/forms/conditional-forms/
  9. Hi, just to update this post. Here are the new and updated links that you can use and refer: Creating a view to filter data: https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-filter-data/ Documentations you can use in counting each persons yes/no responses: https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/ https://howto.caspio.com/datapages/reports/advanced-reporting/data-grouping/ https://howto.caspio.com/getting-started/advanced-reporting/advanced-reporting-1-of-2-grouping-and-aggregation/ (Video tutorial)
  10. Hi, just to update this post. Here are the new and update links that you can use and refer. Creating custom link that will separate results from details page: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/results-and-details-on-two-separate-web-pages/ SEO Deployment Guide: https://howto.caspio.com/deployment/seo-deployment-directions/ https://howto.caspio.com/faq/deployment/seo-deployment/
  11. Putting the calculations in JS is much faster. My page took 2 minutes to load; it is down to about a second. There is a limit to 10,000 characters in one HTML block so I'm working on splitting it out.
  12. Thanks Glitchindoodle. I'll try this one.
  13. 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
  14. Hi there! I have a formula in my table, it doesn't seem to work. [@field: A] + [@field: B] So, these are actually text fields. So the values inside are currencies. $100, something like that. How would I be able to add them now? When I use the syntax above, it's only concatenating them.
  15. ISNULL stills seems to be working for me. If it were true that ISNULL will be deprecated, what should we use as a replacement?
  16. 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.
  17. I totally forgot about the triggered actions! Thanks for reminding me. I'll explore into that. Anyway, the max limit they can submit is 12 per submission. Kinda like a card they need to fill in. Once they have 12 purchases they get a free product.
  18. The source of the submission is different from where you get all rows. There are 3 tables here. One is QTY which has one Integer field holding 1 to 50. Two same tables MultiSubmit and MutliSubmitDetails. Submission is based on MultiSubmit and MutliSubmitDetails are having all rows including the initial row.
  19. If you explain what the form is for there might also be better ways
  20. Using JS to have multi submit is not a good idea specifically if you have a number of for instance 15 ~ 20 or more. Instead you can get the Purchase_count from the form and have as triggered actions based on the source table which adds info for that many times you want to repeat this in your table.
  21. Hello, I'm trying to figure out how to filer records with a text field that contains comma delimited values. The problem is the search doesn't actually recognize 'delimited' in a field and so 'contains' will bring up records that I need to filter out. For example, if a record's text field has a value of 1,2,3,4,12,22 the user might do a search/filter; "‘contains 2” (it can’t do = 2 because the actual value of the field is “1,2,3,4,12,22” and “2” won’t be equal to it). But the ‘contains’ function will bring up records with not only ‘2’ in them but also ’12’ and ’22’ etc. I tried using "" in the search box so "2" would bring up records with just 2 and not 12 or 22, etc, but this doesn't work either. Does anyone know how to deal with this? I can't use List for data type as these records are imported and you can't import to List fields. The value 1,2,3,4,12,22 denotes a multi-record, meaning that record is related to 6 different records in another table. Thanks for any help!
  22. @TaxGuy I've got a page with 30+ calculations and it is also insanely slow. Every time I ask support, they tell me to make it into a multi-step form, which is unacceptable for my workflow. I too am looking for a solution for better speeds. I haven't tried doing calculations into html blocks simply because that is a ton of work with the amount of calcs I have lol. I will eventually try it out when I get time. If you find a solution, please let me know!
  23. Hi all, I'm fairly new to javascript and I'm working on this frequent buyer website. What I'm trying to do is to submit the form multiple times base on user input. I have this code: <SCRIPT> document.addEventListener('BeforeFormSubmit', function (event) { var countx = document.querySelector('[id*=Purchase_count'); for (var i=1;i < countx.value;i++) { document.getElementById("caspioform").submit(); } }) </SCRIPT> Is there a reason why it's not working properly in google chrome but works fine on Edge? Here's my datapage: https://c1abc789.caspio.com/dp/3dca7000a203fdee67e14f3ebfa1 Feel free to submit some test records. Thanks in advance for any help I can get on this.
  24. Hi @JaredL, You can add it into the Header after disabling HTML editor on th Advanced tab: <style> select option { background-color: green; font-weight: bold; color: red; } </style> or you can add the code into the User-defined styles in to the Styles menu: select option { background-color: green; font-weight: bold; color: red; }
  25. Hello Alison thank you for your response. Where do I place this code? in the header & Footer or I go to styling? thanks!
  26. For future reference, here's a video guide on how to create a separate search form and result page:
  27. I am building at tax application which, as would be expected, has several complex formulas. I have pushed as much as I can back into the table but the inability to use a table calculated field in a subsequent table field means the heaviest formulas, all based on Case selections need to be performed on the data page. My load time averages a little over 2 minutes, which is unacceptable. If I put the calculations in an HTML block and do the calculations there, does that speed things up?
  1. Load more activity
  • Create New...