-
Posts
1,510 -
Joined
-
Last visited
-
Days Won
83
Everything posted by MayMusic
-
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/
-
Where do you see those broken links? On Caspio pages?
-
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)
-
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>
-
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.
-
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.
-
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.
-
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
-
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.
-
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.
-
List and File data types are not available
-
HTML Button change colors based on Date
MayMusic replied to Gurpreet's question in General Questions
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 .... -
Incrementing field values when button is clicked
MayMusic replied to SDKHunter's question in Calculations and aggregations
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/ -
Check these ready-made apps https://www.caspio.com/apps/
-
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)
-
On your Details/Report page where you show the data you need " Render value as: " HTML
-
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]
-
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
-
Multiple submission base on user input
MayMusic replied to Syvill's topic in User JavaScript and CSS Discussions
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. -
Multiple submission base on user input
MayMusic replied to Syvill's topic in User JavaScript and CSS Discussions
If you explain what the form is for there might also be better ways -
Multiple submission base on user input
MayMusic replied to Syvill's topic in User JavaScript and CSS Discussions
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. -
have you create the folders yourself? Try to remove that form your path in here and see if that helps.