Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 03/06/2020 in all areas

  1. Hello @SaraK, Thank you for the detailed explanation. You have made a big research on this as well and were so close. Please try to use the following formula in the Calculated field to get the number of IDs that were Submitted Today: SELECT COUNT([@field:Request_ID]) FROM curbsideEntries WHERE DateDiff(day, [@field:Timestamp], SysDateTime())=0 Hope this helps! Please let me know if it works for your case. Regards
    2 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. 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
  10. 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
  11. Barbie

    Hide Search button

    Hi Watusi, You can try to paste this code in your header instead: <style> input[class*="cbSearchButton"]{ display:none !important; } </style> I hope this works for you.
    2 points
  12. Thanks a lot for your replies kpcollier ! I'll check it out. Kind regards Johan
    1 point
  13. kpcollier

    Property Management App

    @Cheryl I think you should give both of them a unique ID. I would have a units table and a building table. Make a 'Building ID' integer field in the Units table. In Relationships, connect the ID field of the Building table to the Integer field you created in the Unit table. Now each unit is assigned a building, and you don't have a big mess of either having a table with a mix of units and buildings and the rest of the fields nor a bunch of repeating 'unit' fields in your business table. This will make it easier to edit and update each individual unit. From there, you can make a Vie
    1 point
  14. Hi @wimtracking2, For more information about, CSS property you may check and test it at https://www.w3schools.com/cssref/playit.asp?filename=playcss_display&preval=inline Here is a helpful article on how to customize your DataPage: https://howto.caspio.com/tech-tips-and-articles/common-customizations/tech-tip-5-ways-to-customize-the-look-of-your-datapages/
    1 point
  15. Just in case somebody prefers JS over rules, you can try the following code too. You need to add Header&Footer for your DataPage Elements and paste this to the Footer (with HTML Editor disabled on the Advanced tab). This code will also hide all of the 8 fields until something is selected from the dropdown. If you want them all to be initially shown, just remove the 2 lines that say "//hide all fields on page load''. <script type="text/javascript"> function hide(fields){ fields.forEach(el => el.style.cssText = "display: none;"); } document.addEventListener('DataPageRea
    1 point
  16. <style> .cbFormData { display: flex !important; } </style> Perhaps you can use this CSS code to override the CSS styles for radio buttons.
    1 point
  17. I did this one last year https://c1abz415.caspio.com/dp/8c4b6000a85530fe3c4c4440a562 If this is what you wanted to achieve, then yes, this can be done by rules. You may have a lot of Rules Actions but the key is to do a reverse and instead do them from the criteria. Here's how I did it: 1. Pulled up the n number of fields. Make sure that there is a selector, in this case a virtual field that were divided from the rest of the fields via section. 2. From the Rules tab, create a rule. Remember that the number of rules will depend on the number of fields that will be
    1 point
  18. Hello @VincenzoCocciolo, If you would like to perform the same aggregate function on multiple field columns, you can add multiple fields to one aggregation, and the results will automatically appear in one row but in the appropriate column. Otherwise, if you need different calculations for each column, you must use multiple aggregate fields and it will appear in different rows. Please refer to the Totals and Aggregations article. Also, you may look into the Pivot instead of the Tabular Report DataPage. I found the forum post with a similar issue that may help you: Feel fre
    1 point
  19. I just had a thought for my own question... In case others run into this, my thought is to export my app (without any data) before doing a data import; then switch my column datatypes as needed; do my data import; switch the column datatypes back; then import the app back into Caspio so that my datapage is back to normal.
    1 point
  20. Hello @nanglin, I see. Since there is the code to submit the form in the "else if" condition, once the Submit button is clicked, 2 records are submitted. As I understand, the email field is unique in the table, so you see the message regarding the duplicates. Please remove the else if condition and test the DataPage. <script> document.addEventListener('BeforeFormSubmit', function(event) { let checkValue = document.querySelector("[id*='cbParamVirtual2']").value; if (checkValue == '0') { event.preventDefault(); alert("Your domain is incorrect
    1 point
  21. Bloom

    Disable Autocomplete

    /* Turn autocomplete off on form*/ document.getElementById("caspioform").setAttribute("autocomplete", "off"); /* Turn autocomplete off on each input text element*/ if (document.getElementsByTagName("input").length > 0) { var inputElements = document.getElementsByTagName("input"); for (i=0; i < inputElements.length ; i++) { if (inputElements[i].getAttribute("type") == "text") { var att = document.createAttribute("autocomplete"); att.value = "off"; inputElements[i].setAttributeNode(att); } } }
    1 point
  22. Hello @TeamVilla, It looks like the Master/Detail tables are equal to Parent/Child tables. A Parent table is the table that stores the primary key (a field that uniquely identifies the table records). A Child table is the table that references the parent with a foreign key. Here is the article https://howto.caspio.com/tables-and-views/relationships/database-relationships/ I believe, that Domain table is equal to Lookup table (Countries_table, Months_of_the_Year_table, etc. ). It stores data you've pulled out of your table to make the table smaller. You may set the
    1 point
  23. Hi Team, It is possible format the output result page fields to have a grid just like a table in Excel? Thank you in advance
    1 point
  24. Hello, just to add in the previous comment above. As I understand, you want to create a search field which can search to the different 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] + ' ' + [@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
  25. Thanks a lot @sandy159! I actually figured that by myself but thanks all the same. Really appreciated. I'm just starting to learn this platform
    1 point
  26. Hello @databydesign, Welcome to the Caspio Forum! CAPTCHA should be available in all plans. You may add it when creating the 'Submission form' DataPage on the "Web Form Wizard - Configure Fields" screen. Please refer to this link: How to add CAPTCHA To add a "list from which to choose location" you may create a Lookup table with the different locations and then use it for the Dropdown, Listbox or Cascading element on the DataPage. You may find the following links helpful: https://howto.caspio.com/tables-and-views/lookup-tables/ https://howto.caspio.com/data
    1 point
  27. Hi @imJihyo Here’s what I’m using for my Report DataPage <a href="mailto:[@field:RecordTextEmail]">Send an email now</a> I tried using this in an HTML Block and Footer and it both works. Just make sure to change [@field:RecordTextEmail] to the field you want to use. I suggest using the field picker since it is easier. Here’s the link to my Test DataPage as well for you to see: https://c2abn197.caspio.com/dp/adf580003e27c8c147304009bce8 I hope this helps!
    1 point
  28. Hello @roattw, Once the field is being hidden using rules and this specific field has default value, the value itself will not be stored inside the table once submitted since it is hidden and considered as non existing field. If you want to achieve your current workflow, you may need a JavaScript code that will hide a field based on a checkbox. If you are familiar with Javascript, you may use the code below, paste it in the Footer and play around with it: <script> document.addEventListener("DataPageReady", function() { field = document.querySelector('input[id^="InsertRecord
    1 point
  29. Hello @mruns, If you want your calculator to display calculated values without the user actually submitting any data to the table, you will need to add Virtual Field to your Submission form. Just select the Virtual Field from the picker and then set Form element to Calculated Value. Please refer to the screenshot below. Hope this helps!
    1 point
  30. Hi @roattw, You are getting this error because you are trying to enable two Triggered Actions that runs on insert. As per https://howto.caspio.com/tables-and-views/triggered-actions/ You will need to put it in one Triggered action since it also run during insert. I hope this helps!
    1 point
  31. You may want to try checking the Web Services Integration (API) thingy. https://howto.caspio.com/web-services-api/ However, its kind of complicated. Cant use it myself so I stick with multiple scheduled import and rely on the best practices they suggested: https://howto.caspio.com/tables-and-views/scheduled-import-and-export/scheduled-tasks-datahub/#:~:text=Best Practices,of high-speed data transfer. Quack
    1 point
  32. I have done this in the past by duplicating my app. I then make the changes in the duplicated app for testing purposes. After everything is done, what you could do is export the new app as Caspio XML format, and then import and replace it to your existing app provided all of the naming conventions are the same. The alternative to importing would be to change your datapages to the new ones.
    1 point
  33. 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
  34. 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
  35. The answer is, use a date diff day function. kindof like this: Hope it helps, Quack.
    1 point
  36. 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
  37. 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
  38. 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
  39. @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
  40. 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
  41. 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>
    1 point
  42. 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
  43. Hello @mhand To implement such a workflow you may use JavaScript. Paste this code into the Header of the Submission form: <script type="text/javascript"> function inputHandler() { document.getElementById('InsertRecordTrxnType').value = document.getElementById('cbParamVirtual1').value //cbParamVirtual1 needs to be changed according to the name of the Virtual field you have in your DataPage } document.addEventListener('BeforeFormSubmit', inputHandler); </script> Note that cbParamVirtual1 needs to be changed according to the name of the Virtual field you have in you
    1 point
  44. boulerjt

    Caspio User

    I have the same question regarding the second problem you described. Any luck resolving this "active" checkbox issue?
    1 point
  45. NiceDuck

    Save history of the field

    This is how I did it by a triggered action. Note, with this workflow, you would be able to keep the previous value of a field, it will not save the value of newly inserted record. first, duplicate the table which you want to have a history record. go to its table design and change its ID field to a text 255 and rename it "parent_id" or any name you want. Your call, as long as it indicates that it is the records former ID. also, make sure that this field is not set to unique. Add an Id field and name it "History_Id" this will be the records actual ID on its current table. this is
    1 point
  46. 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
  47. LittleMsGinger

    PageViewIncrement

    Hello @Watusi, You cannot display the value of the field in Details Page if it is set to PageViewIncrement. However, you can insert a calculated field and pass the value to it. Just like this: Hope this helps. Regards, kristina
    1 point
  48. I have not tried the code but syntax needs a little modification: <script src="https://code.jquery.com/jquery-3.2.1.min.js"></script> <script> $(document).ready(function(){ $("table[data-cb-name='cbTable']").removeAttr("title"); }); </script>
    1 point
  49. MayMusic

    HTML Datasource Grayed Out

    You cannot have any source for HTML DataPages, since you cannot use to read or write to a table. But still you can authenticate it and get parameters from authentication on this page
    1 point
  50. It is better if you hide the section using JS Around that section add HTML Block one on top and have : <div id="section1"> Below it add another HTML Block : </div> Use a code in following format to hide the div in last HTML Block after closing div <script> if (CONDITION){ document.getElementById('section1').style.display:none; } else { document.getElementById('section1').style.display:block; } </script>
    1 point
×
×
  • Create New...