Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Tubby last won the day on October 12

Tubby had the most liked content!

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. This can be added using an HTML block. Caspio has this article for displaying the search button inline. https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/display-the-submit-or-search-button-inline/ You will just need to tinker with it a bit to make it a magnifying glass picture instead a normal "Search" button. Try using this code below inside the source of an HTML block: <style> .cbSearchButtonContainer { display: none !important; } .cbHTMLBlockContainer{ padding: 35px 15px 0px 15px !important; } </style> <input type="image" src="https://img.icons8.com/color/48/000000/search--v1.png" alt="Submit" width="24" height="24" id="SearchBtn" name="SearchBtn" /> The first style hides the button while the other style overrides the default padding to make the image align with the textboxes since you have the labels on top. Edit what needs to be edited to fit your setup. BTW that icon is just an online icon that I found. Hope that helps^
  2. The blue icon is actually not to signify an existing table relationship. This just means that the table is used by other apps. You can actually see in the screenshot that it is being used by multiple apps. Hence, the blue icon. This might be a hassle to check but an idea that I have is to check all the apps listed on the screenshot (those blue texts can be clicked), click the properties of the table once more and see if there are any datapages, authentications, tasks, etc. in those apps that is using the table. As long as that icon exists, there must be an object that is using the table in another application.
  3. I don't know if this will fit your workflow but I have this CSS code that I am using for a tabular report. I have tested this in a pivot table as well so it should work on your pivot properly: Put this code in the Header: <style> #target table:nth-of-type(1) td:not(:nth-of-type([@FieldtoDisplay])) {display: none;} #target table:nth-of-type(1) th:not(:nth-of-type([@FieldtoDisplay])) {display: none;} /* The part below is for excluding a column from being hidden by default*/ #target table:nth-of-type(1) td:nth-of-type(1) {display: table-cell;} #target table:nth-of-type(1) th:nth-of-type(1) {display: table-cell;} </style> <div id="target"> And this in the Footer: </div> Basically, what this code does is hide all the columns by default except the column specified using the NOT selector of CSS. You can specify your column by passing a parameter from your separate search form [@FieldtoDisplay]. This parameter should contain a integer value that corresponds to the position of the column that needs to be displayed. The second part of the code is optional, it can be added if you wish to diplay a certain column regardless of the selection. Let's say you have a column for ID or Name and you want them to be visible at all times, you can specify their position and change "1" to exclude them from being hidden.
  4. Adding this Article for additional reference: https://howto.caspio.com/datapages/datapage-components/virtual-fields/
  5. Basing off the website, it seems that you can input your values fine. So I am quite confused with the question. Anyways, if you just need some fields to input values without saving them in the table, you can always use "Virtual Fields". Its like fields but not actually. It is a temporary holder of values so you can use them the same way you use Table Fields/Variables. To add a Virtual Field just click the "+" button in the Configure Fields page in the DataPage Edit Wizard and get Virtual Fields. You can then call that Virtual field in the Calculated Values that you are using. (Additional Tip: Virtual Fields can also be set to a Calculated Value for displaying a calculation without saving it to table)
  6. If you have it set up as NiceDuck described, and you are sure that the parameter name in the URL is the same with the [@parameter_name], you should be getting it. A good test is to try calling it by itself first before applying to a button to see if a value is being received. You can just like disable html editor on the HTML datapage and put [@testparam] then preview it. If it show the value then you are receiving it and might just a problem in using the value for the redirection.
  7. Since Caspio's Styles works similar to a CSS stylesheet, if you can manage to get all classes and elements of the the style that you want to use then I believe you can use them as App Parameters. But the difficult part would be coming up with a script to call that app parameter and apply it to the page first before starting the download/print since you will technically need to refresh the page in order for the styles to apply. You can also, instead of manually modifying the twin page every single time you updated something on the original, just duplicate the original and change the style so every changes are applied to the twin automatically.
  8. It depends on how complex the form is. I think Submission DataPages do not have a print/download option but since you are not supposed to print without submitting the form. Then you can use a Details Page that looks like a form and enable Download Options for it so you can download it in PDF format. Here is an article for download options: https://howto.caspio.com/faq/reports-datapages/how-to-make-the-details-downloadable-for-users/
  9. AFAIK, views does not have any calculation abilities as it is only used for filtering existing values of the Tables included. A workaround that I can think of instead of using Triggered Actions is to create an Auto-submission form but use a single record update form and receive the ID as parameter. But that would be much slower than triggered actions which happens on the backend instead of the frontend. This is a reference for auto-submit forms:
  10. Adding this article here as it might help when creating Triggered Actions: https://howto.caspio.com/tables-and-views/triggered-actions/
  11. You can use the ISNULL function for each field and set it to zero to have the null fields converted to zero. Something like this: ISNULL([@field:number1],0) + ISNULL([@field:number2],0) + ISNULL([@field:number3],0) + ISNULL([@field:number4],0)
  12. I think @kpcollier's suggestion is correct. My guess is your current task must be comparing the Timestamp and Expiration_Date field down to the seconds (or maybe even milliseconds) which might be the reason why it is not sending any messages because 10/14/2021 02:10:45 is not equal to 10/14/2021 02:10:46. Something like that.
  13. Here is a reference to the "HTML block method" : https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/
  14. You can use javascript to get the copy the value of the first date field's criteria and pass it to the other fields then hide them so it would show only the first date field with 2 criteria (start and end). There is quite a lot of steps to follow here but it worked for me. First, add two Criteria to all of them. One for Start Date, another for End Date. Configure one criteria as “Greater than or Equal” and the other as “Less Than or Equal” to include all Dates within the selected range. This goes for every single one of the date fields. Afterwards, hide all of the Date Fields except for the first Date field using what I call the "HTML block method". Like this: Just use the same code I used on HTML Block 1 then put </div></div> to HTML Block 2. This creates a separate section for those fields and hides them. Next, add a Header and Footer block and put the script below in the Footer. Dont forget to disable HTML editor: <script> document.addEventListener('input', function drange() { document.getElementById('Value3_1').value = document.getElementById('Value1_1').value; document.getElementById('Value3_2').value = document.getElementById('Value1_2').value; document.getElementById('Value4_1').value = document.getElementById('Value1_1').value; document.getElementById('Value4_2').value = document.getElementById('Value1_2').value; }); </script> But note that this is assuming that the Date fields are positioned at the very top of the DataPage Wizard. The ID 'Value3_1' can change depending on the position. A good way to check is to remove the codes in the HTML blocks to unhide the fields first and inspect the element using F12. Lastly, go to the Logic section and set the Logic to be multiple AND blocks inside a big OR blocks like this: This basically copies and pastes the dates in the first date fields to the others pass them secretly.
  15. Unfortunately there is no way to download the logs in the new UI. But you can still access the old user logs by typing this to the URL: https://<accountID>.caspio.com/ui/userlogs Just change <accountID> to your account ID which you can find in account settings.
  • Create New...