Jump to content


Popular Content

Showing content with the highest reputation since 04/21/2019 in all areas

  1. 1 point
    Hi @kpcollier Try this solution: 1. Add a Calculated Field with a syntax similar to this one. CASE WHEN DATEDIFF(day, [@field:date], '[@cbTimestamp]') >= 21 THEN 'Expired' END 2. Add an HTML Block with this Syntax <span custom-data="[@calcfield:1]">[@field:date*]</span> 3.) Easily style this HTML Markup in your Styles (CSS Rules). I'd suggest, in the header: You can post this everywhere you want: <style> [custom-data="Expired"] { background-color: red; } </style> Hope this helps. `DN31337!
  2. 1 point
    hi @kpcollier, I believe what you want is a UNION of both tables, and NOT a VIEW. Here's a good article differentiating the two: https://www.essentialsql.com/what-is-the-difference-between-a-join-and-a-union/ Unfortunately, Caspio does not have a direct table operation that allows UNION of both tables. The closest we can do is to create another table that has the common fields of your first two tables. We can, then populate the new table with Triggered Actions or Tasks to yield your desired result. After, then, just use the new table as your DataSource. I hope this helps. DN31337
  3. 1 point
    Here's the link where you can submit a form to consult to their Professional Services team: https://www.caspio.com/services/professional-services/
  4. 1 point
    Hi @kpcollier, You can try to add and customize the button style for you to be able to do that. For Example, you can try this similar workflow: Add this code in the header of your search form: <style> input[type="button"] { background-color: #008CBA; width: 150px; color: white; padding: 5px; text-align: center; text-decoration: none; display: inline-block; font-size: 14px; } #customstyle { position: fixed; padding: 24px 3px; margin: -69px -10px; cursor: pointer; } </style> Then insert an HTML Block in the very bottom of the search form to add this code: <div id="customstyle"> <input type="button" value="Go to Google" onclick="window.location.href='https://google.com/'" /> </br> </br> <input type="button" value="Caspio site" onclick="window.location.href='https://caspio.com/'"/> </br> </br> <input type="button" value="Check YouTube" onclick="window.location.href='https://youtube.com/'"/> <div> Important note: - Add the button(s) (HTML Block) in the very last part of the form. - Check "Continue next element on the same line" in the advanced option of the field before the HTML Block where the button is located: - Make sure that you unchecked the "Enable HTML editor" in the advance option of your Header and HTML Block. - This is a custom CSS code and adjustment/configuration might not be compatible in your current search form so you will need to change the (padding and margin) to adjust them. You can check the result here: https://c1abv183.caspio.com/dp/482760006540f98089034387a563 I hope this helps ~WatashiwaJin~
  5. 1 point
    @jnordstrand, have you tried enabling 'Automatically focus cursor on first field'?
  6. 1 point
    Think of 'action' as your 'Tech Status'. > By default, it will not return a 'Tech Status' of Completed > You can add another criteria for 'Tech Status' to filter with other values as well > The only time Tech Status = 'Completed' will be returned is if Criteria Two is checked, or if other criteria were satisfies such condition `DN31337
  7. 1 point
    Hi @kpcollier, I believe you can switch the comparison operator for "Tech_Status" to "Not Equal". Hope this helps. Regards, vitalikssssss
  8. 1 point


    Hi @Jess147, First off, I would suggest using a triggered action in your main table to calculate the total of the column, then send the value to another field from the table where you will insert the data. To do this, you will need to add an INSERT block, select the table where you want to insert the data --> Now set the field that will contain the total calculation and send to another field that will receive the value to the selected table. Here's the screen capture of my sample triggered action. I hope this helps. ~ H
  9. 1 point

    Center Pop-up window

    Hello @FinTheHuman, You can try to use this custom code to center your pop-up window: <script language="javascript" type="text/javascript"> function OpenPopupCenter(pageURL, title, w, h) { var left = (screen.width - w) + 1350; var top = (screen.height - h) / 10; var targetWin = window.open(pageURL, title, 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=no, copyhistory=no, width=' + w + ', height=' + h + ', left=' + left +', top=' + top); } </script> <button onclick="OpenPopupCenter('http://www.google.com', '', 800, 1000);">Go to Google</button> You can change the following data in this line of code: You can try this sample URL for testing: https://c1abv183.caspio.com/dp/482760007ae3812e935c495e9514 I hope this helps ~WatashiwaJin~
  10. 1 point
    If that is the case, you can create a TASK instead of a triggered action. The difference is that it will run on a scheduled basis and will move the percent for all matching names.
  11. 1 point

    Exporting Data

    Hi @Role21, You can enable the Download options on your Report DataPage. Select Download as Excel. So, you can be able to download the data on your Calculated Fields. -JolliBeng
  12. 1 point


    Hi @Jess147, You can achieve that using Cascading Elements. First, you need to set your field1 as an AutoComplete field. Filter it by the field on your LookUp table and use Contains. Then, set your field2 as a Cascading Dropdown. I hope this helps. -JolliBeng
  13. 1 point


    Hi @Jess147, You can achieve that workflow using triggered actions. But first, the records that needs to be calculated should be saved on your table. I suggest that you use Formula fields for calculations or directly calculate it under your triggered actions. You may refer to the following links: https://howto.caspio.com/tables-and-views/data-types/formula-fields/ https://howto.caspio.com/tables-and-views/triggered-actions/ -JolliBeng
  14. 1 point
    Hello @wvantongeren You can implement this workflow using View, Trigger and Task. Find the application with needed functionality attached - Forum_Post_wvantongeren_1_0_2019-Apr-30_1016.zip Let me describe the logic of the application. 1. You need to create an additional table with all Companies. Within the table, you need to have a field to define the status of the company for today. It can be Yes/No field, let's say. You need to create a relationship between your Main table and Companies table. After, you need to create a trigger within the Main table on Insert action to check the usage field of a related company. 2. You need to create a view based on the companies table. The filter of the view is the Usage field needs to be unchecked. We will use this view as the lookup source for Radio buttons field within datapage. As soon as a user submits a new entry, the company will disappear because the chosen company is in usage now and it does not match the view filter. 3. The last step is to create the task which will uncheck the usage field on the daily base.
  15. 1 point

    Filestor URL for Image

    Yes, this is exactly what I was needing!!!
  16. 1 point
    Hi @kpcollier, You can check the status before the update to make sure it is not equal to the list of previous statuses. Here is an example for one of the Trigger blocks: Hope this helps. Regards, vitalikssssss
  17. 1 point

    Trigger Sum

    You should add the sum to the inserted Value. Reading the trigger, You are only summing up the CommentHRS. Meaning to say, the inserted one is still excluded, since you are still on the process of inserting the Data. I hope this helps.
  18. 1 point
    Hi @joneslovescaspio, I contacted Caspio Support and they have replicated the issue for me which I no longer need to do it myself as well. Here are their steps of Replication: 1. We have created 2 DataPages (Test Replace, and Test Replace_1) and configured them differently. 2. Then, we selected 'Test Replace_1' and selected More > Replace, from the DataPage. 3. We were able to select 'Test Replace' and confirm the replace of the configurations of the DataPage from Test Replace_1 to Test Replace. Upon success of Replace: All of the configurations from 'Test Replace_1' DataPage are transferred to the 'Test Replace' DataPage. I have also attached their confirmation dialog box for reference. I hope this helps.
  19. 1 point

    Parse a Comma Separated Field

    Sometime ago a used this kind of formula to parse large amounts of users FullName info First Name: IsNull(Left([@field:FullName],(Patindex('%,%', [@field:FullName])-1)),' ') Last Name: IsNull(Right([@field:FullName],( Len([@field:FullName])-Patindex('%,%', [@field:FullName]))),' ') Formula for Parsing Values formCollumn: FullName
  20. 1 point
    Hi @Alison, You can design Trigger in such a way which allow you to achieve the desired functionality. You need to make sure that: 1. Your parent/child table has one-to-many relationship; 2. You create a special table which will be used as insert template. 3. Please note that you would need to list the same number of records in insert template as the number of days which you could have in the date range. 4. You need to create a Trigger. You may import my example into your account and check the structure there. Regards, vitalikssssss Submit_multiple_records_date_range_1_0_2018-Sep-28_1423.zip
  21. 1 point
    When you're receiving an error: "Authorization failed. Each Google Drive account can only be used once as a Site." setting up DataHub/Scheduled import, you need to check your Google Account Settings. Go to Sign-in & Security and then Apps with Account access. Check if Caspio DataHub is already on the list. Then click Manage Apps, and remove access to Caspio DataHub. Go inside your Caspio Bridge and re-established the connection.
  • Create New...