Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 09/20/2019 in all areas

  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. Hey @taylorswiftlover, Yes, this is possible. On a table level, I have tried them using Triggered actions:
    1 point
  16. 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
  17. Hi @Joanne, the way how you reference fields is incorrect for Inline Edit action of Tabular report and also you need to use a special event to capture the moment then user clicked on Edit/Update button/link. You may try to use the following snippet, however make sure that name of the fields are correct and have prefix "InlineEdit". <script> document.addEventListener('DOMSubtreeModified', function(){ let element = document.querySelector('[id*="InlineEdit"]'); if (element) { let regExp = /^[0-9]+$/; //Change the name of the fields let arr
    1 point
  18. 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
  19. 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
  20. Hello @crionsynx You may use additional formula field to get needed layout. Here is the example: CONVERT(nvarchar, [@field:asdwasd], 101) + ' ' + CONVERT(nvarchar, [@field:asdwasd], 108)
    1 point
  21. 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
  22. That makes sense. They should update with that point. Will play around with it.... while listening to Peaches En Regalia
    1 point
  23. 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
  24. Eureka! As per deemuss's reply/suggestion this is exactly what I need to do.
    1 point
  25. I had such an issue and 'Use display value on DataPages' worked for me. For some reason it is unchecked by default
    1 point
  26. Many thanks for this kpcollier, really useful info.
    1 point
  27. Can you provide a wire-frame of the flow that way we can see what's supposed to happen. Like: Product = GARMENT X Serial Number = 123456 Emp Id = TestID-00001 Station = Choices (Station A, Station B, etc) Then create the wire-frame for us to look at ... like this example below, except show your form fields w/names and what should happen with it's use (It will help us to figure out the flow/logic.)
    1 point
  28. Thx kpcollier. My brain always goes direction that I screwed up some code somehow. Will start referencing that Known Issues more. I do think internally they would have a hot topic/issue awareness about that
    1 point
  29. Shiro

    Email Blocklist

    I just want to share this. If you ever need to prevent your triggered action/ task on sending emails/sms on certain numbers. You can create a table which contains all those unwanted email addresses/ phone number and create a blocklist. It is just an extra condition on the where statement if you used a 'select from' block. Hope it helps...
    1 point
  30. 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
  31. 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
  32. 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 (
    1 point
  33. Hastur

    Link in Group by row

    Hello @NickO To make links from the labels of the second level of grouping, please use this code: <script> function appendLink(elems) { let detailsLink = "https://account_id.caspio.com/dp/datapage_app_key?param="; for(let elem of elems) { let link = document.createElement('a'); link.href = detailsLink + '?param=' + elem.innerText; link.innerText = elem.innerText; link.style.cssText = "color: white; font-size: 12px; font-family: Arial, sans-serif; font-weight: normal;"; elem.innerText = ''; elem.appendChild(link); } }; document.addEventListener('D
    1 point
  34. 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
  35. One solution to this is using a Calculated Value as the form element with this formula: CAST(null as datetime) If you wish to hide this field, you may use HTML Blocks: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/
    1 point
  36. 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
  37. Yolanda

    data transfer

    Hi Vitalikssssss - I didn't find the answer I just want to know how much data is used by every search? Is that calculated by the size of the records? p.e. if by a search I get 20 records as result does that count as more data transfered then if the result is only one record?
    1 point
  38. 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
  39. Please try to change the data type of your PhoneNumber field to Text.
    1 point
  40. AtayBalunbalunan

    Failed logins

    No, in the event of a password reset, the lockout time will be cleared.
    1 point
  41. kpcollier

    Letter-Style DataPage

    Yes I did! I used it with just a few CSS tweaks and it worked perfectly for my needs. It is what I am currently using. I appreciate it, @SunakoChan!
    1 point
  42. Hello @kpcollier You can implement a similar workflow if you create datapages "on the fly". It can be done if your datapages use AJAX. All datapages are AJAX by default. First of all, you should create a wrapper div where you will load a new step datapage. On each step of submission, you need to define the custom event to clear wrapper and load new datapage. This event should be fired on click of next/prev buttons. Example of the function: function createPage() { var dataPage = document.createElement('script'); dataPage.src = 'https://your_domen.caspio.com/dp/your_app
    1 point
  43. Hello @kpcollier I think that the better idea will be to use Cascading to restrict the amount of values you get in multi-select list box. You can check this article to get familiar with this feature - https://howto.caspio.com/datapages/datapage-components/cascading-elements/ You can use virtual field to define to category. Then you may use this field as the parent field to get appropriate set of options in multi-select list box.
    1 point
  44. 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
  45. Hi @kpcollier-Try this, just enable the source then paste it: <div style="text-align: center;"><span style="font-size:14px;">Capital Glass, Inc.<br /> SM Bid / Work Order</span> <hr /><span style="font-size:14px;"><br /> Job/Customer Name: _________________________________________ Phone #: _______________________<br /> Contact Name: ______________________________________________ Phone #: _______________________<br /> Fax Number: ______________________________________ E-Mail: __________________________________<br /> Jo
    1 point
  46. 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
  47. 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
  48. Hi, I'm creating a triggered action to send inserted records by email when its complies a list of criteria that are setted by the users. But in this list of criteria there are two "multi-select listboxes", and I'm not finding a way to use these listboxes as entry data to configure the triggered action. Is it possible? Thanks
    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. TsiBiRu

    Is CASPIO worth it?

    Hi @mickenzy, Just to add up to the previous comment above, I think this platform is a great platform. It is a low-code or no-code platform that is designed for the businessman or individual with minimal or no technical knowledge at all in coding/programming. This platform will allow us to translate our business ideas to fully functional Applications by only using their point and click interface. Learning to use the platform is not difficult, they have a lot of learning materials that you can use to familiarize with the features of this platform and fully. Caspio also offers fre
    1 point
×
×
  • Create New...