Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. Yesterday
  3. Excellent. thank you. I will give this a try next time. I ended up renaming my fields, it wasn't as time consuming as I thought, but will look into what you've shared in future scenarios.
  4. Assuming your DataPage A is a submission form, this is possible if you enable the On exit: Pass field value as parameter. Upon submission, your Single Record Update form will capture this parameter if you have this. Just ensure that AJAX is enabled for both DataPages. https://howto.caspio.com/datapages/ajax-loading/
  5. Last week
  6. Thanks, Leon13! Here is also a reference regarding Charts: https://howto.caspio.com/datapages/charts/
  7. Hi, just to update this post. Here is the new pricing page of Caspio: https://www.caspio.com/pricing/ And the PDF Report Generation is only available in Grow and higher Plans.
  8. Hi, just to give you some new information. here is the new pricing page of Caspio: https://www.caspio.com/pricing/
  9. Hi @Sansa2016, You need to disable the HTML editor before you input the code. For reference you may check this link: https://howto.caspio.com/faq/web-forms/how-to-disable-html-editor-in-datapage-headerfooter-and-html-blocks/ Have a good one and stay safe!
  10. Hi @VAP1, Just an update, for new version of Styles and when your DataPage's configuration is set to "enable responsive". Here's the new code:Header: <style> #target table:nth-of-type(1) td:nth-of-type(5) {display: none;} #target table:nth-of-type(1) th:nth-of-type(5) {display: none;} </style> </header> <div id="target"> <header> Footer: </footer> </div> <footer> Have a good one!
  11. Hello-- I'm trying to create a formula that would populate a field based on when an application was submitted. For example, if submitted between Aug 1 and Dec 1, then the field value would be 'Cycle 1' I was thinking I could use a formula, but I', not getting it to work how I imagine... CASE WHEN [@field:Date_Created_in_Caspio] >= '01/08/2020' AND <= '01/12/2020' THEN 'Cycle 1' END Thanks for any help!
  12. Excellent solution, worked like a charm. Hastur's solution worked too, but seams to be resource intensive. (Perhaps my machine just acted up..) Thank you both!!
  13. Hello, you can also try getting the nth child but will be a static change of color display. But since the chart will always return the blank in the first line, we can always modify the 1st one to be set as orange. Try pasting this to the header as well: <style> rect.highcharts-point.highcharts-color-0:nth-child(1) { fill: #ffd3a8; } </style> If you want to also apply different colors to the other values, change the bold number to any desired displayed number and it should work as expected.
  14. Hello! To change the color you need to use additional JS code. It will parse the data in chart and change the color according to name of the column. Here is the code: <script type="text/javascript"> document.addEventListener('DataPageReady', chartUpdateHandler); function chartUpdateHandler(event) { var cleaner = function(interv) { clearInterval(interv); } let interv = setInterval(() => { if (!!Highcharts) { const options = Highcharts.charts[0].series[0].data; let data = []; options.forEach(option => { let localData = {}; localData.y = option.y; localData.name = option.name; if(option.name === "(blank)") { localData.color = '#ee5921'; } else { localData.color = '#3186AD'; } data.push(localData); }) Highcharts.charts[0].update({ series: { data: data } }); cleaner(interv); } }, 200); } </script> You need to insert this code into the Header of the report DataPage. Do not forget to disable the HTML editor.
  15. Hi, Hi can I change the color of the column in chart for the blank values. For example, I want the color of the first column (blank) to be color red
  16. Hi @DruidCtba, you may try the solution provided in these articles: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/add-an-option-to-a-public-facing-dropdown/ https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/automatically-add-options-to-dropdowns-and-listboxes/.
  17. I have two datapages. Datapage A contains a dropdown and each value from it has a unique ID. I have a second Datapage a (Single Record Update form) on the same page which I would like to be contingent on the dropdown value selected from Datapage A. I would like to know how and if it is possible to send parameters to another datapage in the same webpage using Caspio? Without using the POST method where I would have to create a query string and use a second webpage.
  18. Hi @mhand, You may try to use the following JavaScript snippet: <script> document.addEventListener('DataPageReady', eventHandler); function eventHandler(){ document.querySelector('input[name="cbParamVirtual4"]').addEventListener('change', copyFields); document.querySelector('input[name="cbParamVirtual5"]').addEventListener('change', copyFields); } function copyFields(e){ const element = e.target.name; if(element === "cbParamVirtual4"){ document.querySelector('#cbDSField1').value = e.target.value; } else if (element === "cbParamVirtual5") { document.querySelector('#cbDSField2').value = e.target.value; } } </script> Regards, vitalikssssss
  19. Hi @Elderberg, JS snippet looks correct. Perhaps you have some Triggered action which interfere with updated records. If not, you can share a whole snippet, so we could help you to narrow down the issue. Regards, vitalikssssss
  20. As a workaround, we can use a Formula field in our table to replace the string line breaks with HTMl <br> tag so it can be rendered via HTML. Replace([@field:WithNewLine], ' ', '<br>') Once we have the HTML Version of the text, we can render it as HTML in our Reports: If doing via HTML Block with scripts, just insert it as HTML: Hope this helps!
  21. I have been able to turn off the "Grid Edit/Exit Grid Edit" link using the script below... Notes This only works because of the current grid edit behaviour where the form opens in the list view first otherwise the class name changes when you click the "Grid Edit" link. You need to use the Class Name per the initial form load before entering Grid Edit. On opening my datapage in list view, I established (using <F12> in Google Chrome) that the Class Name was 'cbResultSetActions....' (full name in script below) so check the Class Name of the item in your own form and update the script accordingly. The script does the following... Gets ALL Class Names and puts them into an array Finds the first instance (hence the [0] as that is the first item in an array) where the Class Name (check your own datapages as may not be the first instance) meets the name of the item to suppress Suppresses the display as opposed to hiding it {Style.Display = 'none' --> this ensures that no blank space is left where the item would have normally been displayed} I had to use Class Name as the ID field is dynamically generated by Caspio which tags on unique numbers to the ID each time you refresh the page. I'm sure you could do a partial ID match by taking a substring of the ID but I didn't need to get that complicated. Insert into Footer section of HTML <script> document.getElementsByClassName('cbResultSetActionsContainerCellspacing cbResultSetActionsContainer cbActionPanel')[0].style.display = 'none'; </script>
  22. Something does not work out at your suggestion.
  23. Hi @kgraham2121 I'm no Caspio expert but have you tried using a tabular report with Grid Edit enabled? I've been looking at these myself and they will allow capture in a spreadsheet type format but I have experience a number of shortcomings with the grid edit view... 1. The datapage does not automatically open in grid edit mode and the user currently has to manually click the "grid edit" hyperlink in top left corner 2. Formatting the grid edit view can be tricky as column widths reset on reopening 3. You cannot use grouping and groups will change to columns as Caspio is expecting data to be entered You can allow Grid Edit by setting up a Tabular Report datapage and then setting Grid Edit flag on the Edit settings per screenshot. I have attached two examples.. The List View is the default that opens even if grid edit is checked. The user must click the Grid Edit link You cannot edit in this mode. Checkboxes, data pickers etc will not work The Grid Edit view where you can enter in a spreadsheet view Date pickers, checkboxes operate as expected Hope you get sorted Cheers Craig
  24. Hi, I am creating an inventory management workflow. Components: Materials List/Table Contains ~200 SKUs/items that we order. Unique identifier is Material number. Also includes Qty/pack, Unit Price, Material Description, Expiration, etc... Consumption/Ordering Tool Tabular Datapage that lists each item, # consumed in last X Days, and some calculations, based on consumption rates, how many would need to be ordered to replace what was consumed, for X number of Days (User Defined) Final piece I'm having trouble figuring out is a simple way for user to count and document how many are still in stock - and then be able to factor that into calculation for how much to order. At a high level - I envisioned a template/form/datapage that starts with the materials list, where user can add a Qty for each item, and the count would be date stamped and its history not lost. Can't get my head around how to get a form to work - because they are designed to update single records - and the workflow requires entering a QTY for ~ 200 unique items. Maybe its a seperate table - just don't know how to make the data entry easy, i.e. user doesn't have to select/add each item to count (like a shopping cart) - the list of items is there at beginning and they just fill in the blanks and then how to reference it and perform calculations based on the counts. I have attached a smample of Materials table and Tabular Datapage layout for reference. Thx in advance for any assistance... Materials_2020-May-26_1541.zip Material Consumption Datapage.xlsx
  25. Hi, I need a tabular report datapage to open in Grid Edit mode on the initial load/rendering of the datapage as the users will be working with a lot of yes/no fields via checkboxes. I thought that only ticking "grid edit" on the datapage setup would achieve this but the list view is used by default and no edits are possible in this mode. Checkboxes also show as values yes/no instead of an actual checkbox. In-line edit means multiple clicks when the user just needs to select/deselect a number of checkboxes. I have been able to force my datapage to switch from in-line to grid edit mode (per the Grid Edit by Default post on August 15th, 2016) but the problem I have is that the datapage is first displayed in list mode mode and then the datapage refreshes (when the script kicks in) to change to grid edit mode which is a very poor user experience & doesn't look very good. You can see in the script that it is emulating a "click" of the grid edit link as opposed to opening the datapage directly into grid edit mode. I can reduce the delay from 500 milliseconds but you still see the list mode open and then change to grid edit mode. I would therefore like to find out if... Is there a way that the datapage can be immediately shown/rendered as a grid edit datapage instead of switching after the initial load? (either via datapage settings or javascript) Is there a way to disable/hide the Grid Edit/Exit Grid Edit link that shows by default? i.e. the user would only ever see the grid edit format for this datapage Would be happy with any methods that provide a clean user experience where the datapage is already set to grid edit mode when they see it. TIA, Craig
  26. Thank you @NiceDuck, will do!
  27. Hi @Vitalikssssss Your solution works brilliantly. Thank you very much! Regards, Craig
  1. Load more activity
  • Create New...