Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Tubby

  1. I think not much has changed with their system security. Check this article https://howto.caspio.com/web-services-api/rest-api/special-considerations/ Getting the Password fields through API is still blocked as it seems. So any information regarding it or the idea that @MattFL has is still not feasible, if I am not mistaken.
  2. If you do not need to edit the said field in your submission form, you can also change it's form element to Calculated Value and use this formula to get the current year. YEAR(SysDateTime()) ~Tubbs
  3. You can try using the Revision History of that page and restore the version before you applied the "load.reload()" function and see if that will help. Although you might lose other progress/changes that you made. There is an option to restore as a new DataPage if you want to be safe. HowTo Article about Revision History: https://howto.caspio.com/datapages/managing-datapages/datapage-revisions/ Also, when trying the restored version, try enabling Deployment and using the URL in incognito (if Chrome) or other browser's as this may still show as the current version due to cache. ~Tubbs
  4. Adding to @Meekeee's comment, you can based the search results on a predefined criteria and then use a different field in your authentication table for the other province that they are working on. (Ex. Province1field, Province2field...). Then in the predefined criteria, use the province field in the project table and add a new criteria to that field. receive the authentication fields (province fields) on load, comparison is Equal, and Logic is OR. Something like this: This way, the table will show either one or both the values received. If the user works for more than 2 provinces, you can add more Criteria to the field and do the same thing.
  5. Is the problem the search form or the tabular results itself? If it is the tabular result, I believe there's not much to improve. If you really need all that columns, then the table is quite condensed already. Their min-width is I think based on either the values of the column or, if there is no values present, the table header's label. So in your case, it is pretty much condensed properly. The only possible adjustment that I can think of is to truncate the Text(64000) values. That should give a few pixels off the screen.
  6. I knew it would require some JS! This works, just dont forget he "Ckb" part of the field's name. Thank you @Meekeee
  7. Hi, Anyone knows how to make the checkbox inside the grid edit pop-up modal checked by default? I am talking about this: I tried looking into the the options in "Configure Fields for Bulk Edit" page but even when set to required, it still needs to be clicked. Any help would be appreciated. ~Tubbs
  8. hi @Ulensr I believe this is related to a bug that I have experienced. This has nothing to do with the number of virtual fields/actual fields in the datapage. I believe it is the name of the field. If the fields are named similarly, with just a single digit as the difference, it affects all fields that are similar. For example, a rule that should be affecting Virtual1, will affect Virtual10,Virtual11,Virtual12, and so on. That might be the reason why section gets "corrupted" since the radio button is using Virtual1 as the field and there is a Virtual10 on section 2. This was confirmed to be a bug by support and I think they are working on it. For now, a workaround is to use other virtual fields such as Virtual5 or higher to avoid this from happening.
  9. Will a View not worked for your case? Since you only need it for a report (if i read the whole thing correctly), you can make a View for Job table and TimeEntry and only include matching records so only the jobs with a record in TimeEntry table will show, eliminating jobs which has not been worked on. I can't seem to see why job table was used when the date fields and hours worked is in TimeEntry (correct me if i am wrong).
  10. Or, if you do not want pop-up tabs, you can maybe pass the search field's value as parameters using the "On Exit" in the advanced tab, create a button in the submission form that redirects back to the tabular report and use query string values to pass the parameters back. Then enable "On load, receive" on the search fields so it will get the same values searched earlier. However, you will still need to hit the "Search" button to apply these search values. The button can be made as something like this : <button onClick="window.location.href='https://datapagedeployURL.com?parameters=[@parameters]';"> Back </button>
  11. I think the reason why it is returning no results is because you technically left the DataPage when you accessed the Submission form since it is not a part of that Search and Report DP. Thus, clearing the search parameters that you have used. I believe you can use a pop-up tab for the submission form instead so the Search form would not close. You can create a simple pop-up link using their link generator in this article: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-generate-link-menus-and-popup-windows/
  12. @roattw You might just be missing the "target." for your year field in the formula. This will avoid the same calculation applying to each row. Check @CoopperBackpack's formula.
  13. Welp. It is still a few pixels over the last column. But I guess it is better than its previous version where it even blocks the scroll down button on smaller screens. I just extend the last column to its maximum width to allow a few spaces on the right side so the bubble doesn't cover any of my data values. I still believe that it is better to put the bubble on the lower left side tho if the blank space there is not going to be utilized anytime soon.
  14. 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^
  15. 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.
  16. 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.
  17. Adding this Article for additional reference: https://howto.caspio.com/datapages/datapage-components/virtual-fields/
  18. 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)
  19. 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.
  20. 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.
  21. 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/
  22. 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:
  23. Adding this article here as it might help when creating Triggered Actions: https://howto.caspio.com/tables-and-views/triggered-actions/
  24. 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)
  25. 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.
  • Create New...