Jump to content


Caspio Evangelist
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by MayMusic

  1. You can request Caspio support to enable orphan file cleanup in your account. There are two type: Manual and Automatic. The program then will run ones a day and looks for the files that are not reference in any tables in your account. These files will be saved in a table called CB_Orphan_Files table and if you choose manual you need to check the files and check remove to have then removed and if automatic they will be removed in 24 hours with the next run time. To read more about this feature refer to this article https://howto.caspio.com/files-and-images/orphan-file-cleanup/
  2. Where do you see those broken links? On Caspio pages?
  3. You can change the form element of your field to be a Calculated Value on your submission page and use the formula below: DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)
  4. Add this code to the header of the screen: <style> .cbFormSelect{ display: inline-block; vertical-align: top; overflow: hidden; border: solid grey 1px; } .cbFormSelect select{ padding: 10px; margin: -5px -20px -5px -5px; } </style>
  5. Java scrip will not get disabled if you disable AJAX, but you need to adjust the code to work. For instance if you are using Caspio event handlers you need to replace them. Refer to this https://howto.caspio.com/release-notes/caspio-bridge-13-0/13-0-impacted-areas/. You need to reverse your code back.
  6. Try to deploy one page and see if WIX is adding frame around it then it will not work. It is better to contact their sales/support and the try the deploy codes to test. For instance implement this sample and then use the deploy codes to test.
  7. You can either open the details page as a popup so user can close when they are done and go back to the report. If you know coding you can open the details on the same page you have deployed your report page. For instance in the block next to results which changes on each click. You can also separate your search and result in 2 pages and pass all the parameters you used to filter your report back to the pre-defined report page.
  8. On your Submission Page configuration for the file field you have the option to choose the folder you want the file to be stored in. You can also add another field to store the thumbnail of the file.
  9. Assign an ID to each section by adding HTML blocks before and after and under advanced tab uncheck HTML editor. HTML Block above: <div id="first_Section"> HTML Block below: </div> Then have a JS to get the value and show/hide the section. If you have the link to the page I can give you the code
  10. So basically if there is a clock in and it is not ye clocked out there should not be any new entry to this table. Is that correct? If that is correct, then you can have a details page which is filtered based on this table to pull the record that Clock out is blank and clock in is not blank. If there is any record that means someone if already working. You can add a message with for instance user name that this person is already working. If there is no record then it means they can submit a new row. This is when this details page returns no records found. You can change this message in Localization and add a JS line to redirect user to submission page. <script>window.location.href="SUBMISSION PAGE URL";</script> apply this localization to your DataPage. Authenticate your details page so user can login and use it as entry point. If they can submit they will be redirected to submission otherwise they see the details or no details of the open task but a message that says there is another open task.
  11. Is the one that is not working authenticated? Maybe you have designated entry page on your login page so it redirects you back to one page.
  12. List and File data types are not available
  13. Hmm ... how do we know if there is any files on share point? If you have a table in Caspio that stores the filed and you have a date field which identifies which dates those files are available then you can have a code to change the color, hide/show buttons ....
  14. You can use triggered actions that runs on the update and increments the value of a field on the other table: https://howto.caspio.com/tables-and-views/triggered-actions/
  15. MayMusic


    Can you elaborate more?
  16. Check these ready-made apps https://www.caspio.com/apps/
  17. 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)
  18. On your Details/Report page where you show the data you need " Render value as: " HTML
  19. 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]
  20. 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
  21. 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.
  22. If you explain what the form is for there might also be better ways
  23. 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.
  24. MayMusic


    You are very welcome
  25. have you create the folders yourself? Try to remove that form your path in here and see if that helps.
  • Create New...