Jump to content


Caspio Moderator
  • Content Count

  • Joined

  • Last visited

  • Days Won


MayMusic last won the day on May 8

MayMusic had the most liked content!

About MayMusic

  • Rank
    Advanced Member
  • Birthday May 19

Recent Profile Visitors

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

  1. What exactly you are you trying to implement? What needs to be tracked?
  2. As I understand you have a Calculated Field in your report page and you are trying to pass that value as a parameter from a report or details page. If that is the case you should be able to select that value from picker and the format is: '[@calcfield:1]' for instance: https://caspio.com?value=[@calcfield:1]
  3. The best is yet to prevent redundant data in your table and include those values only in the parent table and then to generate your pivot you can create a view to join your tables and use it as the source of the report page. But just to answer your question, when a record is being updated/inserted/deleted in a triggered action that manipulated record gets saved to a temporary table called #inserted. What you can do is to compare the column value from the #inserted table with the actual table value and if changed then update the child table with the same ID field.
  4. When you add "!important" to a style class it means ignore subsequent rules, and any usual specificity issues, apply this rule. For instance, if you have p { font-size: 16px; } you can change it to p { font-size: 18px !important; }
  5. MayMusic

    MS Plugin

    Are you using Access plug-in as stated here https://howto.caspio.com/integration/plugin-for-microsoft-office/? Refer to this post https://howto.caspio.com/faq/api-and-microsoft-office-plugin/how-can-i-get-web-services-api-and-plug-in-for-microsoft-office/
  6. The menu is not generated in Caspio but in HTML web page as a template. You can go over the ready-made application and request one: https://www.caspio.com/apps/ When they import it to your account they will also send you the HTML pages with templates. Then you can use that template for your own app.
  7. 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.
  8. You can create a new table with one field and enter the options as values in that lookup table. Then in your form, select dropdown as form element and use this table as the source refer to https://howto.caspio.com/tech-tips-and-articles/common-customizations/adding-an-any-option-to-a-dropdown/
  9. From the picker at the bottom right corner of element panel add a Header (https://howto.caspio.com/datapages/datapage-components/datapage-header-and-footer/) to your page. There is a picker that looks like an arrow facing down, click on it and under authentication select the field you would li ke to see the value for
  10. For the picture to appear you need to have a javascript code as HTML cannot be combined with SQL syntax
  11. If the receiver name should be a valid entry then you can have a dropdown so they can select from. If you do not want to present the names, a workaround would be creating an authentication based on "UserAuthenticationTable" and only include combined_user_name (must be unique in the table) for users to enter (no pass fields). If this is a valid entry then you can proceed and enter more data. User does not have to enter combined_user_name again on this form as it can be received from Authentication.
  12. On a submission DataPage, where the user adds value for the field you want to save the calculation value in you, can select "Calculated Value". Create your formula there and for the selected values on the for select the fields from the picker that looks like an arrow key facing down
  13. You should look for .cbResultSetGridTableHeader and .cbResultSetGridHeaderCell
  14. Clear your browser cache and history and try again. Or try a different browser.
  15. You are welcome. Also keep in mind the calculation in a table can be done only on the data of the same row only.
  • Create New...