Jump to content

MayMusic

Caspio Moderator
  • Content Count

    1,490
  • Joined

  • Last visited

  • Days Won

    67

MayMusic last won the day on September 2

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. The source of the submission is different from where you get all rows. There are 3 tables here. One is QTY which has one Integer field holding 1 to 50. Two same tables MultiSubmit and MutliSubmitDetails. Submission is based on MultiSubmit and MutliSubmitDetails are having all rows including the initial row.
  2. If you explain what the form is for there might also be better ways
  3. Using JS to have multi submit is not a good idea specifically if you have a number of for instance 15 ~ 20 or more. Instead you can get the Purchase_count from the form and have as triggered actions based on the source table which adds info for that many times you want to repeat this in your table.
  4. MayMusic

    Tim

    You are very welcome
  5. have you create the folders yourself? Try to remove that form your path in here and see if that helps.
  6. Have you tried wordpress deploy code? https://howto.caspio.com/deployment/deploying-into-wordpress/
  7. To restrict access to certain rows you need to have user authentication through Caspio as well. Refer to https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/ So users who are using google ID to login first need to be added to your user table which has access level.
  8. Yes you can male Caspio pages to be responsive : https://howto.caspio.com/tech-tips-and-articles/responsive-datapages-overview/ and the next release you will have responsive option as a standard feature
  9. The last inserted value gets to a temporary table before it gets added to the actual table so you need to count the number of rows of #inserted as well and add it to the rest
  10. Yes on can use this JS in the Footer of HTML Block below all your elements: <script> document.getElementById('InsertRecordStampCheckbox').onchange = function (){ if (document.getElementById('InsertRecordStampCheckbox').checked){ document.getElementById('InsertRecordDate').value = '[@cbTimestamp]'; } else {document.getElementById('InsertRecordDate') = '';} }; </script> in 'InsertRecordStampCheckbox ' you need to replace "StampCheckbox" with checkbox field name in "InsertRecordDate" change "Date" with the date field name you want to record the timestamp
  11. To restrict user access to pages you need to create user groups and give access to groups as described here. Tutorial: https://howto.caspio.com/tech-tips-and-articles/common-customizations/create-user-specific-redirect-after-login/ Video: https://howto.caspio.com/getting-started/create-user-specific-redirect-after-login/ To stamp the time user logged in, you can create a submission page based on the table you want to keep logins, and deploy this page as your authentication page. Use the JS on this page to redirect user to their dashboard. You can wither have auto-submi code on this page and use the JS in the tutorial in the message area or use the JS in the footer and modify it to redirect user on page load. For other scenario also you should look for the same workaround
  12. MayMusic

    Tim

    Since input page and update pages are not the same in Caspio and if you save one row in the table for completing the column values you need to create an update form, there needs to be another DataPage to perform this task. Unless with back-end programming.
  13. First change the PlanID data type in your price table to be INTEGER as it is an Autonumber in Plans. Then you can create a report based on Plan table, in report page add a calculated field and use the formula below: If the Date field in Price table is a timestamp on submission then you can use the formula below: SELECT TOP 1 Price FROM Price WHERE PlanID = target.[@field:PlanID] ORDER BY Date DESC
  14. Can you send me a screen shot of your table designs?
×
×
  • Create New...