Jump to content

Leaderboard


Popular Content

Showing content with the highest reputation since 12/18/2019 in all areas

  1. 2 points
    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).onkeyup = function() { formatAsDollars(this); } document.getElementById(element).onchange= function() { formatAsDollars(this); } }); </script> Pay attention to comments. Hope this helps. Vitalikssssss
  2. 1 point
    LittleMsGinger

    onsubmit not working

    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>
  3. 1 point
    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
  4. 1 point
    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
  5. 1 point
    Nevermind! I figured it out. Will post for reference for others: <style> .cbSearchButtonContainer { display: none !important; } </style>
  6. 1 point
    @kpcollier, You can use the following JS code if you decide to use a custom code. <script type="text/javascript"> function calculate() { var subTotal = isNaN(parseFloat(document.getElementById("InsertRecordSubtotal").value)) ? 0 : parseFloat(document.getElementById("InsertRecordSubtotal").value); var markUp = isNaN(parseFloat(document.getElementById("InsertRecordMarkUp").value)) ? 0 : parseFloat(document.getElementById("InsertRecordMarkUp").value) ; var countyTax = isNaN(parseFloat(document.getElementById("InsertRecordCounty_Tax").value)) ? 0 : parseFloat(document.getElementById("InsertRecordCounty_Tax").value); var miscPerc = isNaN(parseFloat(document.getElementById("InsertRecordMisc_Percent").value)) ? 0 : parseFloat(document.getElementById("InsertRecordMisc_Percent").value); var freight = isNaN(parseFloat(document.getElementById("InsertRecordFreight_Total").value)) ? 0 : parseFloat(document.getElementById("InsertRecordFreight_Total").value); var markUpTotal = document.getElementById("InsertRecordMarkUp_Total").value = (subTotal) * (markUp); var countyTaxTotal = document.getElementById("InsertRecordCountyTax_Total").value = (subTotal) * (countyTax); var miscPercTotal = document.getElementById("InsertRecordMisc_Percent_Total").value = (subTotal) * (miscPerc); document.getElementById("cbParamVirtual1").value = (subTotal) + (markUpTotal) + (countyTaxTotal) + (miscPercTotal) + (freight); } setInterval(calculate, 1500); </script> Regards, vitalikssssss
  7. 1 point
    @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 be one of the great unsolved mysteries. Thanks for you assistance!!
  8. 1 point
    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/:
  9. 1 point
    One scheduled task run (successful or failed) is equal to one DataHub call, regardless of the number of tables the scheduled task contains. https://howto.caspio.com/tables-and-views/scheduled-import-and-export/ https://howto.caspio.com/tables-and-views/scheduled-import-and-export/scheduled-import-task/ https://howto.caspio.com/tables-and-views/scheduled-import-and-export/scheduled-export-task/ https://howto.caspio.com/tables-and-views/scheduled-import-and-export/scheduled-tasks-datahub/
  10. 1 point
    Hi, The suggested method is not available yet. Here is another way to accomplish it. Create a calculated field with something like below and have this as part of the email body. SELECT snv_id = 'Not updating your browser already resulted in the following records being submitted with missing info:' + char(10) + STUFF(( SELECT ', ' + snv_id + ' ' + CONVERT(VARCHAR(10), Visit_Date, 101) + ' ' + Client_Last_Name + ' ' + ' ' + Client_First_name + char(10) FROM _v_v_VisitNotes_Browser where _v_v_VisitNotes_Browser.nurse_User_ID_num_SNV= '[@authfield:Nurse_UserName]' FOR XML PATH('') ), 1, 1, '')
  11. 1 point
    AtayBalunbalunan

    Page does not exist

    This may happen after your application has been renamed. Other users of your account might have renamed your application before you navigate to the application's DataPages.
  12. 1 point
    AtayBalunbalunan

    Emails Daily Limit

    When daily email limit is reached, you will see a message in your Messages tab informing about this. Below is an example.
  13. 1 point
    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 = 5) it will space them to overcome this I either used columns of 1 or 5 and if required less then 5 used 1 and had the elements continue on the same line. Your other option would be to build a full HTML table within the HTML block something similar to this; <style> .wrapper { background-color: lightgray; padding: 5px; } td { padding: 10px; } </style> <table border="0" cellpadding="1" cellspacing="1" style="width:100%;"> <tbody> <tr> <td><strong>Some Data 1</strong></td> <td><strong>Some Data 2</strong></td> <td><strong>Some Data 3</strong></td> </tr> <tr> <td class="wrapper">[@field:Some_Data_1]</td> <td class="wrapper">[@field:Some_Data_2]</td> <td class="wrapper">[@field:Some_Data_3]</td> </tr> <tr> <td><strong>Some Data 4</strong></td> <td><strong>Some Data 5</strong></td> <td><strong>Some Data 6</strong></td> </tr> <tr> <td class="wrapper">[@field:Some_Data_4]</td> <td class="wrapper">[@field:Some_Data_5]</td> <td class="wrapper">[@field:Some_Data_6]</td> </tr> </tbody> </table> Which would result in something like; Again you would have to experiment with layout to match the rest of your form/fields but may be a possible solution but without seeing exactly what you want as an end result its a bit hard to offer any further advise. Good luck, Roosta
  14. 1 point
    With the recent Caspio Release 20, the features Variables and Loops on Triggers and Tasks should make this possible. This workflow is pretty advanced, the following are pre-requisites: 1.) Auxiliary (aux) table 2.) An Autonumber field in the table you would be selecting against. (Timestamps would also do, if they can be unique. But let's stick with autonumber. It's much simpler.) Below is a Trigger demonstrating this implementation. On an aux table, create an OnInsert Trigger, that: 1.) Instatiates variables: a. init (min autonumber), b. len (max autonumber), c.) ConcatText (placeholder of the concatenated Email text), d. counter (optional. To count the number of records involved) 2.) Loops through the TABLE we are selecting against, whilst concatenating the involved records. The WHILE loop does magic tricks to select the next lowest autonumber per iteration. 3.) Optional. Update the #inserted.EmailContent with the ConcatText 4.) Actually send the email. This works well on my end. *Except for the counter part. Haha. I just added that last minute. I'm too occupied in making this post comprehensible. Sorry for my bad English. Kidding aside, the EmailContent works well on my end*. ===== You can extend this trigger, perhaps, by: 1.) Adding WHERE clause to limit your DataSets 2.) Create a TASK to insert to this Aux table, therefore effectively creating reminders to your end-users. I hope this helps. DN31337
  15. 1 point
    mbdiener

    User Authentication Failed

    @Alison, Thanks for your reply. Your comments regarding the Authentication configuration made me realize what the problem was. The authentication Caspio method automatically chose the UserID and password for authentication. However, the UserID was the autogenerated unique record number, not the Username, which I was inputting. I changed the method to use the Username and all worked fine! Thanks again for answering.
  16. 1 point
    Hello Two weeks ago, I was wondering if we can make a submission form with a distance search. What we are trying to do is basically make a text-field where the user will input his or her location then there will be a dropdown button or list which only contains locations in our record which is within 30 miles from the user. We thought we can make via cascading element. However, after a short communication with the support, they informed us that It is not possible do that via dropdown. I found an alternative workflow though. First, I made a Data Page with a distance search. The user will have to input their location via zipcode then it will return all records within 30 miles from it on the results. Then I passed this value as a parameter on my submission form via link. It is working fine for for us now but its kinda lot of work plus it cost us two data pages for a single process. I hope if help others but please comment if you have a better idea in mind. quack
  17. 1 point
    Hi, You can also add a simple CSS code on your Style to enforce Uppercase in the input fields of your Submission form. You just need to follow these steps: Edit the Style that you are using. On the DataPage Elements, go to Form Details -> Fields Click Source tab, Look for .cbFormTextField and add this code: text-transform: uppercase; ~JolliBeng
×
×
  • Create New...