Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 12/03/2019 in Posts

  1. Hi @bbewley, @kpcollier, You may try using this JS which should go to the Footer: <script type="text/javascript"> function formatAsDollars(el) { el.value = el.value.replace(/[^\d]/g,'').replace(/(\d\d?)$/,'$1').replace(/^0+/,'').replace( /\d{1,3}(?=(\d{3})+(?!\d))/g , "$&,"); el.value = el.value ? '$' + el.value : ''; } let fields = ["FIELD_1", "FIELD_2"]; //specify your fields here fields.forEach(element => { element = "InsertRecord" + element; // replace "InsertRecord" with "EditRecord" for Details/Single Record Update DP document.getElementById(element).onkey
    3 points
  2. Hello @roeithemeiriman, If you created a Trial account, as I remember it will be deleted automatically in 14 days. No action is required from your part. In case you created a Free account, you can easily delete it. Please go to the top menu Account -> Usage and Billing -> Cancel Account. Here are screenshots for better visualization. Screenshot_1 Screenshot_2
    2 points
  3. Hi @MaraMara, To move your "Record Action buttons column" to the first column you may follow the next steps: 1. Go to Styles and open the styles that you are using for the DataPage 2. Select Table Layout under Results Page 3. Under Element Type, look for Record Action Column 4. On the Position dropdown, change the position to Left. 5. Click Save then go to your DataPage then apply this Style Hope this helps!
    2 points
  4. Thanks to both of you. Learned a lot here. Great to be a new member with such helpful fellow members!
    2 points
  5. Just leaving this here ... <script> document.addEventListener('DataPageReady', function(event) { function hideControlsForPerson() { var table = typeof document.getElementsByClassName("cbResultSetTable" + event.detail.uniqueSuffix)[0] == "undefined" ? document.getElementsByClassName("cbResultSetTable")[0] : document.getElementsByClassName("cbResultSetTable" + event.detail.uniqueSuffix)[0]; // Find the index of the last column, which happens to be the inline edit/delete var total_num_columns = table.rows[0].cells.length; var controlsCo
    2 points
  6. An Agent from Chat support gave me this doc. Its not official but I hope it helps quack: Table Variables .pdf
    2 points
  7. Hello @CoopperBackpack You may use additional JS code to implement this workflow: <script type="text/javascript"> document.addEventListener('DataPageReady', fileInputEvent) function fileInputEvent() { document.querySelector("#InsertRecordFile_f"),addEventListener('change', fileInputHandler); // use the InsertRecord[your file field name] instead document.removeEventListener('DataPageReady', fileInputEvent) } function fileInputHandler(event) { const fileSizeInput = document.querySelector('#InsertRecordFile_size'); // use the InsertRecord[your file size field name] instead fi
    2 points
  8. Hi, Does anyone know how/where to change the css in the Styles for the Bulk Edit link when it's hovered over, for a tabular datapage. I can change the style for the link in Source/Page Action section: .cbResultSetBulkEditActionLink { /*Results Page Bulk Edit ActionLink Attributes (For Gallery And List Pages)*/ color: green; font-family: Arial, sans-serif; font-size: 14px; font-weight: 600; text-decoration: none; } However, this only changes the link style when it's not hovered over. When hovered over the 'Bulk Edit' link reverts to its defa
    2 points
  9. You may use the code below to hide fields in the new responsive feature <table style = "display:none;"> <tr> <td> FieldA FieldB </td> </tr> </table>
    2 points
  10. Caspio Bridge 21.0 release brought a Tasks\Trigger enhancement which solve this case without complex Trigger\Tasks. There is a new block added to Triggered Action called "Table variable" which forms a table. You can insert table variable into email body and it will be formed link a table (HTML format enabled): Hope it helps someone.
    2 points
  11. Hi @Johnn, You can use FormSubmitted event handler. I saw it in the howto article: https://howto.caspio.com/datapages/ajax-loading/ <script type="text/javascript"> document.addEventListener('FormSubmitted', function(event) { alert('Submitted'); }); </script>
    2 points
  12. Please ensure that you don't have referential integrity enabled in you table relationship. According to the note in https://howto.caspio.com/tables-and-views/triggered-actions/:
    2 points
  13. Hi @roattw If this is a submission form I assume you mean something like this; Where you can have headings over each section? If so you can split the form up into sections with columns to suit and have HTML block in-between their own sections set at 1 column to span the page like this; This is one column proceeded by the HTML block with the next section containing the submission form fields; You will have to experiment (a lot!) to get decent results and spacing for your whole form as if you start mixing section columns other then 1 and X (in my case X
    2 points
  14. It is possible to set checkmark condition using Calculated Value. The field should be set as Calculated Value The basic formula to set the condition is: CASE WHEN [@field:IntegerValue]=100 THEN 'X' ELSE 'Y' END For Yes/No field, the boolean value us 1/0. However, to make it work properly, the field should receive BIT value. So, CAST function should be applied: CASE WHEN [@field:IntegerValue]=100 THEN CAST(1 as bit) ELSE CAST(0 as bit) END
    2 points
  15. 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!
    2 points
  16. Hello @sandy159, You may try to add this code to the DataPage Footer section: <script type="text/javascript"> document.addEventListener('DataPageReady', updateColor); function updateColor() { const recordsListArr = document.querySelectorAll('[id*=InsertRecord]'); recordsListArr.forEach(element=>element.addEventListener('change', (event) => { element.style.backgroundColor = '#acdbdf'; }) )}; </script> By this code we select all source fields that have the following Form elements: Text Field/Text Area/Dropdown/Listbox. You may customize the ba
    1 point
  17. Hi, just to add to the previous comment above. If you have created a Trial account it will be automatically be deleted after 14 days. All the resources and objects in your Caspio Bridge account will also be deleted.
    1 point
  18. Hello, just to add in the previous comment above. As I understand, you want to create a search field which can search to the 2 fields, right? If that is the case, on your table, add another field and set it to Formula. Then, concatenate the fields you want to use in your report. If all your field are in Text datatype , you can use [@field:FieldName1] + ' ' + [@field:FieldName2] on your Formula Field. Then, use this formula field as your search criteria, it should look like the attached screenshot. I hope that helps.
    1 point
  19. sandy159, Thank you very much for the suggestion. I used inline bulk editing and it worked like a charm! I really appreciate the help.
    1 point
  20. Hi - I want to hide the message 'No record found ' and the header of the DataPage.
    1 point
  21. I noticed that one as well. For now, what I did is I made a dummy datapage to host that image for me, then from there, right click on the image then select the 'get image address'. You will then have a URL which you may now use for the image on authentication instead of pulling it from app parameter itself. image on authentication.docx
    1 point
  22. You may try this formula: CASE WHEN [@field:FirstName1] = ' ' THEN IsNull([@field:LastName1], ' ') + ' ' + IsNull([@field:FirstName2], ' ') + ' ' + IsNull([@field:LastName2], ' ') WHEN [@field:LastName1] = ' ' THEN IsNull([@field:FirstName1], ' ') + ' ' + IsNull([@field:FirstName2], ' ') + ' ' + IsNull([@field:LastName2], ' ') WHEN [@field:FirstName2] = ' ' THEN IsNull([@field:FirstName1], ' ') + ' ' + IsNull([@field:LastName1], ' ') + ' ' + IsNull([@field:LastName2], ' ') WHEN [@field:LastName2] = ' ' THEN IsNull([@field:FirstName1], ' ') + ' ' + IsNull([
    1 point
  23. astroboy

    Users not completed form

    Hello @drmt1979, one possible way that I can think of to achieve this is to create a Triggered Action that will stamp the status of the entry as 'completed' upon submit and then you may create a view to filter out the users that have not completed the form based on the status field. You may check the following articles for reference: Triggered Actions - https://howto.caspio.com/tables-and-views/triggered-actions/ View - https://howto.caspio.com/tables-and-views/what-are-views/ I hope this helps. Cheers!
    1 point
  24. Hello there, You might want to check your authentication configurations, specifically the 'Timeout and Redirection' and see if you have anything set there that might be causing this issue. You may check this HowTo article for more information: https://howto.caspio.com/authentications-and-connections/authentication/ If this is an isolated case, you may try clearing your browser's cache and see if that works. You may also try to access the DataPage using another browser. I hope this helps. Cheers!
    1 point
  25. Alison

    Online Store

    Hi @Katey, If you have an account with Caspio, you may request the following application and use it as is: https://www.caspio.com/apps/online-store/
    1 point
  26. I havent verified it yet but I think we can have as many connections as we need and they only limit the number of times we can run :/
    1 point
  27. Hello @vanderLeest, Please try this code: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { let title = document.querySelector('#cbParamVirtual2').value; let title1 = document.querySelector('#cbParamVirtual3').value; if (title == title1) { document.querySelector('h4').innerHTML="Add your Invoice"; } else { document.querySelector('h4').innerHTML="Add your Invoice and the Financial Statement Report"; } }); </script> The code should work properly if: 1) you have o
    1 point
  28. The rows in a tabular datapage report display colors when they are clicked to highlight the chosen row. Is the event for this exposed so I can attach a javascript event listener and extract data from the selected row ?
    1 point
  29. Why not use a Details Report? Then show search form with results below it.
    1 point
  30. Ras2019

    HTML Blocks - Responsive

    Hi, On my website where datapages with HTML Blocks are deployed, it seems there is a conflict with the website CSS and the Caspio Style CSS and I cant figure out what custom CSS to put in the styles to avoid such conflict. This is how my HTML Blocks turn out responsive going out our over my container on the site - other data fields adjust fine! Have anyone experienced same issue with HTML Block in responsive sites - and dealt with it? Sincerely Ras
    1 point
  31. Hi All, I was able to make a workaround not to include blank fields in the Automatic email using Calculated Value. I used Virtual fields in this example. Here is the formula: CASE WHEN '[@cbParamVirtual1]' = '' THEN '' ELSE 'Virtual 1: [@cbParamVirtual1]' END + CASE WHEN '[@cbParamVirtual2]' = '' THEN '' ELSE ' Virtual 2: [@cbParamVirtual2]' END + CASE WHEN '[@cbParamVirtual3]' = '' THEN '' ELSE ' Virtual 3: [@cbParamVirtual3]' END + CASE WHEN '[@cbParamVirtual4]' = '' THEN '' ELSE ' Virtual 4: [@cbParamVirtual4]' END You can also test this DataPage. I did not hide the Vi
    1 point
  32. I tried to move the title of a chart from middle to left using Styles and CSS but no luck. Is there a workaround to do this?
    1 point
  33. @guardmetrics The calculated field should look like this in: CAST((( DATEDIFF(minute, [@field:Patrol_Activity_Database_Date], [@field:Patrol_Activity_Database_1_Date]) - (DATEDIFF(minute, [@field:Patrol_Activity_Database_Date], [@field:Patrol_Activity_Database_1_Date]) % 60) ) / 60) AS nvarchar) + ':' + CAST((DATEDIFF(minute, [@field:Patrol_Activity_Database_Date], [@field:Patrol_Activity_Database_1_Date]) % 60) AS nvarchar) Also you may find other examples here -
    1 point
  34. One solution for this is to have an "Other" option in your field and a new field (text element) where your user can type and will hold a value for the "Other" option. The new field can be hidden at first and will just show once "Other" is selected using Rules. If you want the new field's value to be copied in the first field upon submission, you can use trigger for that. Here is a documentation: https://howto.caspio.com/tables-and-views/triggered-actions/
    1 point
  35. That makes sense. They should update with that point. Will play around with it.... while listening to Peaches En Regalia
    1 point
  36. SinJunYoung

    Camera only option

    Hello, from your file upload options, you can only have the option to also get the mobile camera based on what phone you are using. However, disabling the file upload option is not available as a standard feature. Here in this article: https://howto.caspio.com/files-and-images/uploading-files-and-images/, you can only also choose to display the uploaded file as an image I hope this helps.
    1 point
  37. boulerjt

    Caspio User

    I have the same question regarding the second problem you described. Any luck resolving this "active" checkbox issue?
    1 point
  38. I tried to do this some time last year and couldn't figure it out. Obviously, it is not a standard feature (surprise) so it's gotta be something JS. When I was going through this, I initially was trying to just toggle hide/unhide the rest of the input fields with a button, but I couldn't figure out a good way to use a single button to loop through the rest of the input fields one by one. Another problem was removing the input fields if too many were summoned. (Maybe add another 'X' button by each field that when clicked, would hide the field?) I never finished this workflow and just went
    1 point
  39. Hi @kpcollier, Try the following JavaScript: <script type="text/javascript"> function formatAsDollars(el) { el.value = el.value.replace(/[^\d]/g,'').replace(/(\d\d?)$/,'$1').replace(/^0+/,'').replace( /\d{1,3}(?=(\d{3})+(?!\d))/g , "$&,"); el.value = el.value ? '$' + el.value : ''; } var fields = ["Subtotal", "MarkUp", "County_Tax", "Misc_Percent", "Freight_Total"]; //specify your fields here fields.forEach(element => { element = "InsertRecord" + element; // replace "InsertRecord" with "EditRecord" for Details/Single Record Update DP document.getElementById(el
    1 point
  40. Hi, We have also experienced this kind of message when we try to access our Web forms in Safari browsers. We asked Caspio Support for some assistance about this. As per them, "We have noticed that after the recent release of iOS 13, some users with Safari version 13.x have reported intermittent issues signing into Caspio applications. We are monitoring each iOS/Safari release so we can provide a solution that will fully support a stable release of Safari. Caspio has added an overlaying message on Safari browser (only v.13+) that is used to access DataPages: “This version of Safari i
    1 point
  41. Hi @Chrille, You should use "EditRecord" prefix on Details page in order to reference a field. So, you code should look like this: <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function (event) { var v3 = '<img src="http://image_url" alt="YES"'; var v2 = document.getElementById("EditRecordKontaktad").value; if (v2 !="") { document.getElementById("EditRecordRingt").value = v3; }}); </script> Hope this helps. Regards, vitalikssssss
    1 point
  42. NiceDuck

    Barcode

    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
    1 point
  43. @AtayBalunbalunan, Thanks for your reply. I am deploying the Datapage on a self hosted WordPress website. I've tried it both using the Embed and WordPress (with plug-in) deploy methods. I tested the direct link in Firefox, I did see the authentication fields. I then tried the page on Microsoft Edge and that worked. On a whim, I decided to try it again on Firefox and now the fields display! I really don't know how to explain it, but it probably has something to do with cache and/or cookies, which I did clear when previously testing. I guess as long as it continues working it will
    1 point
  44. Hello, One question for my Information (data pages) uploaded in Caspio. 1)Eventual disclosure to third parties you make, if any, for all information I will upload: please list3rd party entities in case; 2)Erasing / right to oblivion policies in places at your end for all the information I upload. How I can control it. Thanks Roberto
    1 point
  45. Hi @BFuchs Your code is not working for all rows since you are generating several items with the same id "myLink", remember each id must be unique. Could you please identify a field within the table which is unique so I can provide you with the proper JS? Tell me the full name of the unique field.
    1 point
  46. Hi @Vitalikssssss, You should add two text fields to the Selected fields on the Submission form and one of them make a Dropdown form element. After that create a Header and Footer element and past the following code into the footer after disabling HTML edotir: <script> document.addEventListener("DataPageReady", function() { let dropdown = document.getElementById('InsertRecordname'); let textfield = document.getElementById('InsertRecordnumber'); let change = function() { textfield.value = this.options[this.selectedIndex].value; }; if (document.addE
    1 point
  47. You may try adding an HTML Block with the following. <style> table[class^="cbResultSetTable"] { display: none !important; } <style> Please disable HTML editor first.
    1 point
  48. This Triggered Action should relate the #inserted Problem to all of your Verticals in the ProblemVertical table. Note: I used autonumber for the IDs. Export the attached file for live working example Tables_2019-Nov-22_0657.zip
    1 point
  49. Ha! I got this working. I missed the step of having to name the ID for the No Results Message in Localizations. If someone else needs to change the header message when no results are found, this is how. I found some clues using this online help page, https://howto.caspio.com/integration/map-mashup/hiding-the-map-when-no-results-are-found/ Go to Localizations and choose the language you're using, and go to #351 No Records Found. Add a custom message if there isn't already one, and put a div tag around it with an ID, mine is "norecord" for this example. Then add another div
    1 point
  50. I figured this out. I just needed to create a relationship manually between the lookup table and the child table and enforce referential integrity. Seems like referential integrity should be enforced by default when you use the autocomplete feature but it isn't. The only hiccup I had was that I had sample data in the child table which would not, at first, allow me to to enforce referential integrity. I deleted that data in the table and voila. Now, if you type something that isn't in the lookup table, it gives you an error! For a lawyer-turned-pizza operator working on a medical bil
    1 point
×
×
  • Create New...