Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 05/10/2020 in all areas

  1. Thanks @kpcollier and @sandy159 - the difference in days option worked. Appreciate your help.
    2 points
  2. Hello @Gabrielle, Please note that this dropdown shows the tables that have a unique field. The Authentication can be created using the table with the unique field since it`s required to define the specific user. For example, in this table the email field is set to unique: Feel free to update this thread in case of additional questions.
    2 points
  3. 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
  4. 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
  5. 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
  6. Thanks to both of you. Learned a lot here. Great to be a new member with such helpful fellow members!
    2 points
  7. 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
  8. An Agent from Chat support gave me this doc. Its not official but I hope it helps quack: Table Variables .pdf
    2 points
  9. 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
  10. 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
  11. 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
  12. 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
  13. boulerjt

    Caspio User

    I have the same question regarding the second problem you described. Any luck resolving this "active" checkbox issue?
    1 point
  14. Hi guys! Just wanted to add these links about setting up authentications. It's very informative and helped me a lot when I was just starting out with Caspio https://howto.caspio.com/authentications-and-connections/authentication/ - Jihyo ♥
    1 point
  15. Hi @Mollie, just to add, you may also check this Caspio's video tutorial regarding for responsive applications.
    1 point
  16. There use to be a checkbox next to where you name the download in Download Options that would append the current date to the name. But, for some reason, they deleted that and changed it out without telling anyone. I was also looking for this today. Now, you need to click on the 'field picker' next to the name box in Download Options and select the timestamp option.
    1 point
  17. Hello @Mollie, If you are referring to the Caspio DataPages, please use the Responsive option. You may learn more in these articles: https://howto.caspio.com/datapages/responsive-datapages/responsive-datapages/
    1 point
  18. If you're hiding it, you don't need to, you just want to pass the dropdown value if it's changed. Just do script for both, if a dropdown is hidden, they will not be changed anyway, so, the script should not fire. For example I have a dropdown with id cbParamVirtual1 document.getElementById('cbParamVirtual1').addEventListener('change', function() { document.getElementById('InsertRecordTitle').value = document.getElementById('cbParamVirtual1').value; }) for your 2nd dropdown, if it's cbParamVirtual2, just do the same, and rename the Virtual1 document.getElementById('cb
    1 point
  19. Hi, You may try pasting this on the Header DataPage element of your wizard: <style> @media only screen and (min-width: 577px) and (max-width: 1024px) { section[class^="cbFormSection"], section.cbCalendarReport, nav.cbCalendarNavBarPanel, .cbAuthSimpleOuterTable, .cbAuthSidebarOuterTable { margin-left: 0% !important; } </style>
    1 point
  20. I believe Caspio does not have Time only DataType, you have to use DateTime, can't you just use formatting and display time instead? The values in my table
    1 point
  21. Hey there @RossChevalier List data types are designed to accept multiple values. A user Can select just one option, but they Can also choose more than one. Not sure if any script will work for enforcing the field to just accept one choice. You can learn more about that data type here. Depending on your workflow and why you needed to use a list data type, an alternative I can suggest is to use a text 255 data type for these fields instead. It's kinda ideal since if you use it in a submission form, set the form element to a dropdown, it will only accept one value. Plus, since you menti
    1 point
  22. 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
  23. Hi @Vvillie, You can still use the code here. You just need to change "#InsertRecordPhone1" to "#Value1_1" Hope this helps!
    1 point
  24. I have a report data page that utilizes a details page and on this details page, all fields are display only. I am wanting to format the details page so that the information is displayed more consistently. I see how text fields, for example, can be manipulated with the pixels and other options, but those options are not available when using display only. All of my fields are display only as we do not want any editing of values on this data page. Was hoping someone could tell me how to control the width of displayed information for fields that are form element:display only? I found the
    1 point
  25. Someone just posted about this. You may refer to this post. If it's okay with you to disable the WordPress theme for that specific page.
    1 point
  26. 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
  27. <style> .cbFormData { display: flex !important; } </style> Perhaps you can use this CSS code to override the CSS styles for radio buttons.
    1 point
  28. 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
  29. Hello @nanglin, Please try to paste this code to the Footer section of the Submission form. Disable HTML editor before pasting. <script> document.addEventListener('BeforeFormSubmit', function(event) { let checkValue = document.querySelector("#InsertRecordfield_name").value; //replace the field_name with your local field name if (!checkValue.includes('@123.com')) { event.preventDefault(); alert("Your domain is incorrect, contact your system administrator"); } else { document.forms["caspioform"].submit(); } }) </script> Pleas
    1 point
  30. 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
  31. 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
  32. I found my error: I inserted the id (id="btnAdd") to the input section instead off as part of the div parameters. <div id="btnAdd" style="display:none; justify-content:flex-end; width:50%; padding:0;"> <input class="cbSubmitButton" type="button" ..... (Before I found this error, I also set the page to be responsive.) Thanks so much for you great solution, Sandy159 Floris
    1 point
  33. Hi @SunakoChan, Yes it is possible to format the out put of the gridline of the result page in tabular report using Style. Go to Style > Edit > Result Page > Table Layout > Data Cells > Border color: Change the black(or color that your prefer) and size 1px. Here is the expected result:
    1 point
  34. Got it figured out, after all. If anyone needs this solution. On the Calendar's Detail page, change the line: document.getElementsByName('Submit')[0].onmouseover = function(){ to document.getElementsByName('Mod0EditRecord')[0].onmouseover = function(){ And also change document.getElementById('InsertRecordTasksTimeline_CalDate').value = date + " " + ampm; to document.getElementById('EditRecordTasksTimeline_CalDate').value = date + " " + ampm; This will find the Update button by name and use it to run the code above in the footer. This will giv
    1 point
  35. 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
  36. Hello community, I have a datapage with a calculated field displaying the DOW based on a date entered by the user using this formula: SELECT DATENAME(dw,[@field:FIELD_NAME]) This works fine. However, I also have 7 Yes/No boxes labeled the DOW i.e. Mon, Tue. Wed.... I'm trying to figure out how to automatically check the appropriate DOW yes/no box to coincide with the DOW being displayed in the calculated field. I also need to change the particular yes/no field to be YES as well as disabled. If the user changes the date and the calculated field then updates with a new DOW th
    1 point
  37. 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
  38. 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
  39. 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
  40. 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
  41. Hello @Umbie, You have 2 options: 1. First create relationships between tables and then build a View based on these tables. In this case when you create a View, on the View Properties screen, the relationships are build automatically. 2. If relationships are not set up and you join tables in a View, you should choose the fields to join tables manually on the View Properties screen. Also, please note that you may find some helpful features only in the Relationship Settings. For example, Enforce Referential Integrity between parent and child table, Display value instead of
    1 point
  42. 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
    1 point
  43. 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
  44. SunakoChan

    Date format

    Hi @Telly, I suppose that you are using Date/Time field. Since it is a Data/time field you have to convert the Field in to text after that use substring for the month, you may use this formula below: CONVERT(VARCHAR, (SUBSTRING('JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC ', ((Datepart(month, [@field: DATEFIELD])) * 4) - 3, 3))) + ' -' + CONVERT(VARCHAR, (Datepart(day, [@field: DATEFIELD))) + ' - ' + CONVERT(VARCHAR, (Datepart(year, [@field: DATEFIELD]))) I hope this helps.
    1 point
  45. I have resolved the issue. Instead of trying to update the entire record i just update the specific field in question - and i have added the where-clause. $postdata = "TestTable2_SMS_sendt":true} and '/views/' . $name . "/records?q.where=" . $columnname . "=" . $columnvalue; 'Hope this can help others :-)
    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. Hello, if you are using Styles, you may want to edit it here: Go to Styles > Edit Style > From the DataPage Elements go to Results Page and Select on Table Layout > Data Cells > and the Layout Options > Wrap Text: No Wrap
    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. JavaScript Tips: Caspio Form Elements JavaScript is a client-side scripting language that is commonly used in HTML pages. JavaScript can be used in Caspio Bridge DataPages to extend capabilities outside the standard features. This page provides a guideline for referencing Caspio form elements using JavaScript. It is an advanced topic and you should have prior knowledge of JavaScript programming. Referencing Caspio Form Elements A common way to access a form element using JavaScript is by referencing the element's ID attribute using: - document.getElementById("id")
    1 point
×
×
  • Create New...