Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 09/23/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 I want to share something with you guys again. Back then when I only have an 'explore plan', I'm using this workflow to send acknowledgement/notification emails on different persons base on a value of a field in my submission form. My workflow back then is I have a submission form for job applicants. I want to send an email to a certain member of my company depending on which position the applicant is app laying. for example. If the applicant is applying for a staff position, there will be an email an email send to staff manager, If the applicant is applying fo
    3 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. 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
  9. 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
  10. 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
  11. 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
  12. 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
    2 points
  13. You can use the code below as a reference. <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var c_checkbox = document.getElementById("selectAll") ; var elementID = event.detail.uniqueSuffix; function c_event () { if (c_checkbox.checked) { var listBox = document.getElementById('Value1_1' + elementID); for (i = 0; i < listBox.options.length; i++) listBox.options[i].selected = true; } else { var listBox = document.getElementById('Value1_1' + elementID); for (i = 0; i < listBox.options.le
    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. Sherif

    Update calculated field

    In a submission form, Calculated Value (formula) in a number field where; calculated failed equals field A +filed B if i enter A and B manually the result will refresh real time and update automatically if value of filed A and B inserted by java script like time stamp the result filed will not update is there any way to auto refresh the calculated filed or better to understand what is different between manual input typing and java script to insert value for example below works and put the value in field but calculated field will not refresh unless manually
    1 point
  16. These links might help you on this: Getting the element: Setting up the JS code: https://www.universalwebservices.net/web-programming-resources/javascript/change-input-element-type-using-javascript/
    1 point
  17. Hi @KAPITYAN, You may try this workaround. Add a Header/Footer to your form and add the following code in the footer: <script> function setSearchIssue(){ var issue = document.querySelector('input[id*="cbParamVirtual8"]').value; document.getElementById("InsertRecordName").value = issue; } document.querySelector('input[id*="cbParamVirtual8"]').onchange = function() {setSearchIssue()}; </script> Also refer to https://forums.caspio.com/topic/4377-js-guide-caspio-form-elements/ for help on addressing different form elements.
    1 point
  18. Hi @Mik271828, It looks like the Datapage has been deployed within a container which has width <1024 px, hence responsive CSS has been applied on styling. You may disable a responsive option if you do not use Datapages on tablet/mobile devices or go into the Style section -->Source and change the HTML properties related to tablet/phone CSS. Hope this helps. Regards, vitalikssssss
    1 point
  19. Hi @JayDub, If you want to select data from a View, you should add prefix _v_ to the View name. More details can be found here: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ You can join as many tables in the Select statement in the Calculated field as needed. The syntax is the same as in the SQL. However, it will be easier to refer to the View.
    1 point
  20. 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
  21. 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
    1 point
  22. I would like to format the auto-email on submit of an update form as neatly aligned table Vendor Number [@SA_Vendor_ID] Invoice Number [@MS_InvNo] Current Date [@Date()] Total Amount [@MS_InvAmount] Currency (fixed “USD”) SES Number [@MS_SESNo] PO Number [@SA_Purch_Order]
    1 point
  23. Hello @jorgeorbit, There can be different reasons for such an error. Please make sure that you use absolute (not relative) paths for URLs and the “Time out & Redirection” under “Advanced Settings” of your authentication is set to the existing URL. You may follow the related article to learn more about the supposed reasons: https://howto.caspio.com/troubleshooting/errors-and-messages/error-60025/ Hope this helps.
    1 point
  24. Hi @IamBlossom, For File DataTypes, you need to use SQL's "DATALENGTH" to measure if the field has content or not. It is a behavior that NOT NULL or IS NULL will not work for File Datatype. Use this instead: CASE WHEN DATALENGTH([@field:Images]) = 0 THEN 'No image attached' ELSE 'Image available' END Hope this helps!
    1 point
  25. Sherif

    Camera only option

    I would like file filed to allow user to upload file using mobile camera only. And stamp photo with time stamp and user authentication field. I want to disable other file upload options Only mobile camera
    1 point
  26. mgredmond

    Login / Logout / Timeout

    Can someone point me to some clear understanding of the Logout Destination Timeout and redirection Login redirection on success parameters found in the Advanced Settings section of Authentications? They would appear to be intuitive, but they are not. I cannot find a clear understanding of these values or how and when to use them. And I am pretty sure they are causing me some problems. I have created a stand-alone Login page with guidance from the Caspio online help and use the following code: <script> if("[@authfield:tbl_Users_IAMgmt^]" == "Yes"){
    1 point
  27. 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
  28. Eureka! As per deemuss's reply/suggestion this is exactly what I need to do.
    1 point
  29. 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.
    1 point
  30. I had such an issue and 'Use display value on DataPages' worked for me. For some reason it is unchecked by default
    1 point
  31. AtayBalunbalunan

    Trigger and Zapier

    Yes, records inserted via Zapier will execute trigger.
    1 point
  32. You will definitely want someone that is proficient in JavaScript. That is a BIG one with Caspio. There are a lot of things that Caspio is missing in their 'standard' features, and they all seem to be do-able in JS. HTML and CSS is pretty much a given. If they are good at JS, they'll know how to mess with these. Python might be a nice asset for APIs, but again, someone good can do it with JS. Knowledge of some SQL will definitely help with expressions and queries for Calculated Values and Formulas, etc. But that stuff is easier and Live Chat can help with this a lot more than
    1 point
  33. 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
  34. 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 PA
    1 point
  35. 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.
    1 point
  36. 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. Th
    1 point
  37. Hi @Ed727, I assume that you have both Datapages deployed on a web-page with an embed method. You can use a JS which clicks on Submit button if my assumption is correct. Here a a code which you can use on web-page: <script> function submit () { document.querySelector("input[id*='Submit']").click(); } setTimeout(submit, 5000); </script> Hope this helps. Regards, vitalikssssss
    1 point
  38. Just edit the style of your DataPage, select Labels under Results Page, then Non-interactive Header Labels. You can choose the color under Font Options. You may refer to this documentation regarding Styles.
    1 point
  39. Vitalikssssss

    data transfer

    Hi @Yolanda, You can find answer in this blog post: https://blog.caspio.com/update-on-caspios-data-transfer-policy/ Regards, vitalikssssss
    1 point
  40. Please try to change the data type of your PhoneNumber field to Text.
    1 point
  41. Hi @Ed727, I am afraid that long text without HTML tags will be rendered as a single line string. Regards, vitalikssssss
    1 point
  42. MayMusic

    Remove scrollbar on listbox

    Add this code to the header of the screen: <style> .cbFormSelect{ display: inline-block; vertical-align: top; overflow: hidden; border: solid grey 1px; } .cbFormSelect select{ padding: 10px; margin: -5px -20px -5px -5px; } </style>
    1 point
  43. First, I'm not sure why you had to do Full Name and Full Address on your Work Order table when you can structure it the same way as your Clients table (with First_Name, Last_Name, etc... on separate fields). === I haven't reviewed the table design and workflow as well. Haha. But I wanted to mention that formula field values can be referenced in the trigger (Read-only). This means that if you are able to separate the fields you need on a formula field, you may simply set First_Name_Text255 = #inserted.First_Name_Formula on your trigger. Hope this help
    1 point
  44. Hastur

    Bootstrap Classes in Caspio

    Hi @Perzival Unfortunately, it is not possible to use bootstrap classes because Caspio classes has more weight. However, you can use native Caspio styles to get needed layout. Check the Style section and try to create and adjust new one. You can find all the options related to colors of result set in the Results Page -> Table Layout Here you can find all the information related to Caspio Styles - https://howto.caspio.com/styles/
    1 point
  45. AtayBalunbalunan

    Summary Lookup

    Hi Watusi, I have a few summary lookup tables in one of my application that was generated upon my confirmation. When creating a lookup dropdown based on a large table, Caspio recommends generating a Summary Lookup Table to improve performance. You can find this information in this blog post. Summary Lookups are optimized tables containing a static list of the field values automatically filtered for duplicates.
    1 point
  46. Barbie

    Dropdown value

    Hi @Batchini, You can put this &nbsp; on your Display and remove the Value of it.It will now give you a blank value in your drop down option. &nbsp; is an HTML character for a non-breaking space. It's purpose is so that the words won't be broken into two lines by "word-wrap". Since it does that, HTML renders it as a space. Hope this helps. -Barbie
    1 point
  47. Just to add, you may also use the AutoComplete form element and configure it with the below settings.
    1 point
  48. JolliBeng

    PDF Report Page

    Hi, Just to add on @AtayBalunbalunan's comment, if you have a copy of your layout saved as a Word document, you can use the Paste from Word option on your HTML block. In that way, you'll be able to print the details with your desired layout. Here's a screenshot: Also, here's the DataPage I created using that workaround. Click this link. ~JolliBeng
    1 point
  49. 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
    1 point
  50. Hello @TroubleShooter, Try adding this snippet of code in the Header of your Results Page Fields: <style> td.cbResultSetActionCell.cbResultSetData *:nth-child(4n) { display: block; } </style> -DN31337!
    1 point
×
×
  • Create New...