Jump to content


Caspio Evangelist
  • Content count

  • Joined

  • Last visited

  • Days Won


MayMusic last won the day on March 6

MayMusic had the most liked content!

About MayMusic

  • Rank
    Advanced Member
  • Birthday May 19
  1. Sử dụng Video Trong App Hi

    You need to get the embed code of the video by clicking on Share >> Embed and add it to the table source of a report page. Then you can include this code and render it as HTML.
  2. Convert Scientific Notation to Numeric

    What error are you getting? Are you creating a table or adding data to a table?
  3. Turn Off Submission Form after Specific Date

    To hide the entire form you can use the code below: <script> var date= new Date('03/04/2018'); var today = new Date('[@cbTimestamp*]'); if (date < today){ document.getElementById("caspioform").style.display = 'none'; } </script>
  4. Triggered Action Issue

    But then it only works for Insert, for update create another one http://joxi.ru/VrwnKVytKyb76A
  5. Triggered Action Issue

    The newly added or updated value gets first saved to a temp table, so in your select statement you need to get the inserted value and add to the rest. refer to http://joxi.ru/Rmz5R9BHWEQYkr
  6. Calculation From Aggregation

    For instance if you want to pull the second lowest Id for last name Kevin you would have: SELECT TOP 1 Id FROM ( SELECT TOP 2 Id FROM AllData WHERE Last_Name = 'Kevin' ORDER BY Id ASC) AS tt ORDER BY Id DESC
  7. You need to write a custom aggregation with CASE statement for instance: CASE WHEN COUNT(xxxx) > 1 THEN COUNT( xxxx ) ELSE '' END but it will not hide the entire row
  8. Triggered Action for Random IDs

    Look at this screenshot: http://joxi.ru/DrllwvKC470OJr Note, if you have created relationships between you tables, enforce referential integrity should not be checked as trigger fires before inserting data to the parent table so the data in child table is being considered orphan and cannot be added
  9. If you want to add a row in your child table when the parent is being generated, you can easily add a trigger to the parent table on INSERT to insert the ID to the child table. Note if you have a relationship between tables and you checked REFERENTIAL INTEGRITY checked you cannot add the child as the trigger runs first and there is no parent yet to add the child so it is being considered orphan. You need to uncheck that enforce referential integrity in relationships first
  10. Using Caspio in your business

    Yes there are reseller accounts in Caspio. If you go with corporate you get 400 DPs and you can purchase more along the way if you need to. https://www.caspio.com/pricing/
  11. RSS FEED

    An RSS feed is an .xml file that contains your newest content. News aggregators, feed readers, email subscriptions, and podcast lists all pull content from RSS feeds. Refer to https://en.wikipedia.org/wiki/RSS
  12. Data page role.

    This should help you: https://howto.caspio.com/managing-your-account/internal-users-groups-and-api-profiles/
  13. The article is updated with new code: https://howto.caspio.com/authentications-and-connections/authentication/hiding-multiple-login-forms/
  14. How do I code a JavaScript pop up window

    Refer to this article: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-generate-link-menus-and-popup-windows/