Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 04/17/2020 in Posts

  1. 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
  2. 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
  3. 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
  4. 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
  5. Thanks to both of you. Learned a lot here. Great to be a new member with such helpful fellow members!
    2 points
  6. 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
  7. An Agent from Chat support gave me this doc. Its not official but I hope it helps quack: Table Variables .pdf
    2 points
  8. 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
  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. If you want to apply this to any data type, you may do the following in the Styles Page
    1 point
  13. 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
  14. Hello @Eugene, Since Caspio uses the Highcharts library to render Chart DataPages, I have checked the Highcharts documentation https://api.highcharts.com/highcharts/ I was able to find the solution that allows to add spaces between slices for the usual Pie Chart (not 3D Pie Chart). You may paste this code to the Footer section on the "Chart Wizard - Configure Chart Options" screen of your DataPage. Do not forget to disable the HTML editor on the Advanced tab before pasting the code. I put the borderWidth as 3, please use the value that you need. < scri
    1 point
  15. I'm confused what are you using? MultiSelect Dropdown or Listbox, afaik, Listbox doesn't display the concatenation of choices, right? Is this what you're trying to do? https://c2aby549.caspio.com/dp/83ff8000344c2f4c1794467fb6e2
    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. Hi, is there any way that I could move the contents of this iFrame to the left?
    1 point
  18. 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
  19. Hello @NickO, I believe you may use another approach for this Trigger. It is better to avoid using the If-Then block when you can use the Select statement instead. Could you test the Trigger design like this? So, you may add the Select statement by clicking the Gear icon and select the record from the #inserted table that met the criteria. If the criteria are met the email for a group of users is send. Feel free to update this thread in case you have additional questions.
    1 point
  20. 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
  21. Happy to know it helps! You can try changing the colors using this input.SimpleButton { }
    1 point
  22. 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
  23. OK this worked as suggested, thank you! One thing to note for others that may go down this path, it cuts off at 255 characters. So grouping is possible (yay!), but unfortunately displaying the full text area is limited to 255. Thanks again @WatashiwaJin
    1 point
  24. @SinJunYoung This is exactly what I am going for. Thank you for all of the help!
    1 point
  25. 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
  26. 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
  27. Hi, just to add to the previous comment above. If you have created a Trial account it will be automatically be deleted after 14 days. All the resources and objects in your Caspio Bridge account will also be deleted.
    1 point
  28. Hi, I took some code from one of Caspio's demo apps (an appointment scheduler) to create a Time Picker on a Submission form. This works great, allowing far more detailed calendar scheduling than just using the date without a time. The issue is when the user needs to edit the date/time from the Calendar, in Details view. The code doesn't work in this case. I've changed the 'InsertRecord' part to 'EditRecord' but that doesn't seem to make a difference. Is there some difference to calling the code from the Update button vs a Submission button? Any help would be greatly appreciated. Bel
    1 point
  29. 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
  30. 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
  31. Thanks @Vitalikssssss, I am assuming I will need to add the SAML app on G Suite's side, but mostly I was just checking if there was any other option eg just going with Google as a scoail login and restricting the domain or similar. We will set up the SAML app in G Suite and then work on figuring out the necessaries for Caspio, and I'll come back here and share our experience when it's done. Or abandoned :o)
    1 point
  32. astroboy

    Users not completed form

    Hello @drmt1979, one possible way that I can think of to achieve this is to create a Triggered Action that will stamp the status of the entry as 'completed' upon submit and then you may create a view to filter out the users that have not completed the form based on the status field. You may check the following articles for reference: Triggered Actions - https://howto.caspio.com/tables-and-views/triggered-actions/ View - https://howto.caspio.com/tables-and-views/what-are-views/ I hope this helps. Cheers!
    1 point
  33. You also need to avoid inserting a record on the table where your trigger resides if its event is set to "Insert", same for the update or delete. This will cause a recursion error which like the trigger effects are triggering itself causing a loop.
    1 point
  34. Alison, Thank you very much!
    1 point
  35. 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
  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. 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
  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. The answer is, use a date diff day function. kindof like this: Hope it helps, Quack.
    1 point
  41. Hello @vanderLeest, I would like to add, that when you click the expand button, you will be able to add a table: It is possible to select the number of columns and rows, adjust border size, alignment, etc. And when the table is added, you may click the right mouse button to have access to the Table and Cell Properties. Using these properties you may style the table as you like.
    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. boulerjt

    Caspio User

    I have the same question regarding the second problem you described. Any luck resolving this "active" checkbox issue?
    1 point
  44. 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>
    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. Here is the code to create custom search again <a class="cbResultSetSearchAgainLink" href="URL"><img alt="Search again" src="https://c0cmr140.caspio.com/images/dp/SA_magnifier.png" style="vertical-align: text-bottom; border: 0px;" title="Search again" /> Search again</a>
    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...