Jump to content


Caspio Evangelist
  • Content count

  • Joined

  • Last visited

  • Days Won


MayMusic last won the day on January 13

MayMusic had the most liked content!

About MayMusic

  • Rank
    Advanced Member
  • Birthday May 19
  1. @telepet Then You just need to change the destination after record update to be the logout link.
  2. As I understand you have a List-String in the table. Based on the user level the options they can select from should vary .. if it is a regular dropdown or listbox we can filter based on authentication. You can try to add a text field to keep the move_set and then enable multi-selection using provided JS at or And then you can filter the using the security tab
  3. Calculated Field to get individual lines in Text Field

    You can use combination of SUBSTRING and CHARINDEX function to get the values. For instance if the text is in a field called add. First word before first break: SUBSTRING( '[@field:add]', 0,Charindex( '<br />','[@calcfield:4]')) Second word:7 is the length of break : <br /> SUBSTRING( '[@field:add]', Len(SUBSTRING( '[@field:add]', 0,Charindex( '<br />','[@field:add]'))) + 7, Charindex('<br />', SUBSTRING( '[@field:add]', Len(SUBSTRING( '[@field:add]', 1,Charindex( '<br />','[@field:add]'))) + 7, LEN('[@field:add]')) ) ) Third one: SUBSTRING('[@field:add]', Charindex('<br />', SUBSTRING( '[@field:add]', Len(SUBSTRING( '[@field:add]', 1,Charindex( '<br />','[@field:add]'))) +14, Charindex('<br />', LEN('[@field:add]'))) , LEN('[@field:add]') ) +19 , LEN('[@field:add]')) and so on ...
  4. Remove "Data Table" tooltip

    Can you give me the link to your page to take a look at the source code?
  5. You are not calling the second function at all but you call the first one two time. You to change the last line to: document.getElementById("caspioform").onsubmit=calculate2;
  6. If you send some words separated with OR like : John OR Mike and then in your report page receive this value and comparison type should be CONTAINS You need to separate your search and report in two page: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/ Then in the search page add a JS to the Footer of the page to replace the spaces you have on search field with OR. <script> function rep(){ var str= document.getElementById('cbParamVirtual1').value; document.getElementById('cbParamVirtual1').value =str.replace (/ /g, ' OR '); } document.getElementById('Submit').onmouseover = rep; </script> Virtual 1 if the virtual field you added to your search page and you need to check the value to the next page on submit.
  7. Resizing an Iframe

    Take a look at this as well:
  8. Since there is no loop function in built in trigger you need to have Caspio write a trigger in database for you to perform this task
  9. Wanted To Share This Third Party Pdf Generator

    Very interesting thanks for sharing
  10. Not all records showing

    Make sure the type of the DataPage is not Details page it should be either one of these:
  11. Dim Radio Button if already got value

    You can add a script to the footer of the page to check the value of radio button field and then hide this field if it is not blank for instance: <script> if ("[@authfield:hotelpayment]"){ document.getElementById('InsertRecordhotelpayment').style.display="none"; } </script>
  12. As I understand you have a lookup table from which you can auto fill the rest of the fields based on zipcode selection. For each zipcode you should be able to add a new row. If this is the case, you can add a link back to the same submission page in successful message area. For instance: <a href="LINK TO PAGE"> Add more zipcode</a>
  13. Linking Fields to other details page

    So as I understand you have two tables Comany_Table and Employee_Table. One company to many employees. What you need to do is to add Company ID to your Employee table. Then you can create a details page based on Company Table to get the information of the company like the example at https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-create-a-one-to-many-relational-datapage/ In this example Customer Detail is Company Profile and Customer Log can be Employee List. Or you can create a view to join your tables: https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/
  14. Graphing

    If that field is a currency field in your table then you can add a formula field to divide the value by 1000 and then use this in your chart, for the aggregation select Average: And formatting to percentage