Jump to content

All Activity

This stream auto-updates

  1. Past hour
  2. Forgot to mention that you are planning to keep the Group ID hidden! Since there is no option to hide the cascading field, you can hide it by using HTML blocks and other options here: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/
  3. Hai there! Since you are using a look-up table, maybe a cascading form element will work for you? I tried to create a DataPage based on the information you provided. This will also work even if you update or add new KeyCode-GroupIDs. You can learn more about cascading elements here -> https://howto.caspio.com/datapages/datapage-components/cascading-elements/ I hope this helps!
  4. Yesterday
  5. I tried to solve this with an SQL statement in a calculated field. However, I bimped into another problem with my SQL statemet (see otehr post on SQL statement)...
  6. I have encountered the following issue when using SQL statements in a Calculated Value in a DataPage: I want to calculate average scores in a database based on the values in specific fields in the same record. These fields function as filters. Example of record: Company_Name Company_Size_Employees Company_Revenues Score Context_AVG_Employees Context_AVG_Revenues ABC Inc. <100 < 50
  7. Try this on your Details Page Footer basically, it listens if any change ( document.addEventListener('change', function (event)) in the page has been made, if there is, it will disable the button <script> document.addEventListener('DataPageReady', function (event) { document.addEventListener('change', function (event) { document.querySelector("input[id^='Mod0EditRecord']").disabled=true; }); }); </script>
  8. It should work as long as the special character is not included in the query string, since you're only passing an ID, it, most probably, does not have any special characters. This is a workaround, as this is technically not passing all those values, but getting it directly from the table while using the ID field as a reference
  9. Hello @GloriaB, The most important feature of an Update Form is to allow users to update a single record based on an identifying field. This may be done in one of two ways: A record id that is passed to the form as a parameter; User identity field in the associated Authentication or Connection (Record Level Security). As I understand, you are using the first option to receive unique 'Order_Number'. The pop-up window "Shop Update Form" is only shown in the Preview mode of Caspio Bridge to test the DataPage. You will not see it on the deployed page. That is why you are g
  10. Hi. To learn how to add watermarks to PDF files, you may refer to this forum post:
  11. Hi all, Starting from version 26, it is now possible to add watermarks to your Results and Details pages. Note that you can add watermarks to PDF files only. To put a watermark on your result page, go to Search and Report Wizard - Results Page Options > Advanced, checkmark the PDF option and click on the edit icon where the new window will pop up: You may notice additional options for the watermark in the settings. Proceed to the details page to add an image or a text as a watermark following the same approach: The watermark will appear when you download the P
  12. Last week
  13. If you are not familiar with Calculated fields, I would highly suggest to check this awesome documentation from Caspio that helped me understand this feature/function. Here is the link my friends: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/
  14. I experienced this once when I am creating a rule for one of my DataPages and I noticed that my section has some required fields that is why it is not allowing me to disable the section. Therefore, I looked back at my fields and not include any of the required fields in that specific section. I have read the articled from Caspio the action limitation in Conditional forms, I believe this might help you out in the long run. (https://howto.caspio.com/datapages/forms/conditional-forms/)
  15. Hi, I wish to disable a specific section and the option for that section doesn't appear when I go to Actions? Why? or how to enter that section in?
  16. Hi, I created a DataPage that is a record update type. The DataPage requires input of a value from a unique field, that is identified as unique in the underlying data table. In preview mode on my desktop computer, the form works fine. I enter the unique value, and it goes to the next step of allowing a variety of fields to be updated. If some data is already in those fields, it shows what the current value is. My problem is when I use the deployed link. If I put the link into either chrome or firefox I get the incorrect result. The response "Not Records Found" is what I see wi
  17. Hello @TellMeWhy, will this also work if my parameter has special characters included?
  18. Hi all, In addition to previous responses, make sure that when you concatenate fields, convert it to Text(255) as well if you would like to use this Formula Field in Field for Value. Concatenating two Text(255) fields, makes the Formula Field as Text(64000). Refer to this formula: Convert(nvarchar(255), [@field:First_name] + ' ' + [@field:Last_name]) Hope this helps.
  19. Hi @DesiLogi, As I understand, you would like to display the results or records for the current week upon loading. You don't need to calculate for the Start Date to be Sunday and End Date to be Saturday. You may use Current Week for the Comparison Type: Then, if you still need to have search form, you can add new criteria. The Logic will be: Hope this helps.
  20. There is an update on the terms of service in Caspio that I wanted to share in this link: https://www.caspio.com/caspio-bridge-terms-of-service/ and if you decided to have an account in Caspio you can check their account plans here: https://www.caspio.com/pricing/
  21. We can indeed do this via Triggered Action. If I got it correct, you want to get the average value from specific field, starting from the total value of all the records on the table as well as the value of the newly inserted. Then save the computed average to another field on the newly inserted. If that is the case, you can normally use a trigger like this:
  22. As I know, the formula comes first before the trigger since it automatically produce value once the record is created even though they are still on the #inserted. As for why your workflow does not work, may you please give me a screenshot of trigger as well as the formula you are using?
  23. Hi @BirdsInTheSky, You may display checkbox on the left with the following workaround. Copy and paste text for the checkbox label into the Display Text. Then, on the Advanced tab change the Label position to 'No label'. On the DataPage it will look like this: Hope this helps! Feel free to update this thread, maybe someone has another approach to this.
  24. Hi Caspio Community! I am new member here, please help. In my submission form, I want to align checkboxes on the left. Means that label will be displayed on the right. Right now I can see options for Label position: Top or Left or No label? But no Label position: Right. Do I need to change it in Styles somewhere or is there a simple CSS for this? What is the trick? Thanks
  25. When creating a Formula field, please make sure to have knowledge about the best practices as well. I suggest you check this article from Caspio: https://howto.caspio.com/tables-and-views/data-types/formula-fields/ This helps a lot.
  26. Hi there I have a table with formula DataType. I want to transfer the result of the formula to another Table via a Triggered Action -> This is not working. So I was wondering if there is a sequence to be respected and if I should perform the formula calulation also in the triggered action ? Thanks for helping me out on this. Johan
  27. Hi everyone, Just want to add information about this. You can also check these HowTo links for reference. https://howto.caspio.com/parameters/parameters-as-query-string-values/ https://howto.caspio.com/parameters/passing-parameters/
  1. Load more activity
  • Create New...