Jump to content

MayMusic

Caspio Moderator
  • Content Count

    1,496
  • Joined

  • Last visited

  • Days Won

    69

Everything posted by MayMusic

  1. MayMusic

    Mr

    Can you elaborate more?
  2. Check these ready-made apps https://www.caspio.com/apps/
  3. Make sure you are not getting 0 by this statement: ([@field:Regular_Runs]+[@field:SPED_Runs]) as division by 0 is not allowed. Try to change your formula to : ([@field:Elig_Reg_Riders]+[@field:Elig_Spec_Need_Riders])/(CASE WHEN ([@field:Regular_Runs]+[@field:SPED_Runs]) = 0 THEN 1 ELSE ([@field:Regular_Runs]+[@field:SPED_Runs]) END)
  4. On your Details/Report page where you show the data you need " Render value as: " HTML
  5. What you have a password recovery to reset forgotten password. Here is what you need to do: 1- Add a GUID field to the user table and call it: GUID and add another field call it "Verified" 2- Create a view to filter the table to only pull the records that verified is not checked. 3- Create a single record update form based on your user table and check to receive external parameter in this format: [@GUID] 4- Select Password and Verified fields 5- In configuration page make Verified to be hidden and Check by default 6- Finish and click deploy to get the URL to this page 7- Edit your submission page where you register the users and create a link to this page in the email body. The link should be: http://XXXXXX/dp/XXXXX?GUID=[@field:GUID]
  6. When you enable grouping on a field that field is being selected in ' Search and Report Wizard - Results Page Options ' screen as default sort order and the only option you have is to change it from A~Z to Z~A
  7. 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.
  8. If you explain what the form is for there might also be better ways
  9. 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.
  10. MayMusic

    Tim

    You are very welcome
  11. have you create the folders yourself? Try to remove that form your path in here and see if that helps.
  12. Have you tried wordpress deploy code? https://howto.caspio.com/deployment/deploying-into-wordpress/
  13. 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.
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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.
  19. 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
  20. Can you send me a screen shot of your table designs?
  21. You can either add a formula field to your table or choose Calculated Value for that combination field on your submission form, use SQL syntax as mentioned by @D3Melb above to get the value in the table.
  22. Please send a screenshot of your table relationships and elaborate on that what you are trying to achieve
  23. Since you want to get the latest price for a product , you need to have the product unique ID in WHERE clause. SELECT TOP 1 Price_Price FROM Price WHERE Product_ID= target.[@field:Product_ID] ORDER BY Date desc
  24. You can create a report based on your product table and then add a calculated field to the report page to read the most recent price for that product. For instance in the code below you are sorting the table by the date price was added descending and getting the first price from the PriceTable. SELECT TOP 1 Price FROM PriceTable WHERE Product_ID = target.[@field:Product_ID] ORDER BY Date DESC
×
×
  • Create New...