MayMusic got a reaction from ManonG in Auto Submit Dropdown
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.
MayMusic got a reaction from Prophecy in Dynamic Sections in Datapages
Assign an ID to each section by adding HTML blocks before and after and under advanced tab uncheck HTML editor.
HTML Block above:
HTML Block below:
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
MayMusic got a reaction from Syvill in Multiple submission base on user input
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.
MayMusic got a reaction from Deanne in Elimate custom value on dropdown
This is not customizable by standard features. You can either have a default value or not. But using JS. you can count the number of options in the dropdown when it is fully loaded and if there is only two then remove the first option.
MayMusic got a reaction from yoinkadventures in Hide "Register as new user" after logged in
It is better to have the link to the registration page and also a link to retrieve the password in the footer of the Authentication. Edit your authentication and use the + Sign to add Header/Footer and create your hyperlinks in the Footer of the page. So the user will always see the login and two links to register or retrieve password.
MayMusic got a reaction from Vitalikssssss in Total Hours Worked / Datediff
Count the total mins either in the table or as cal field on your report. Here we call it TimeSpan
Then in the aggregation use that to get the total:
CAST ((SUM(TimeSpan)/60) AS VARCHAR(6)) + ':' +CAST ((SUM(TimeSpan)%60) AS VARCHAR(2))
MayMusic got a reaction from jafranklin77 in Phone number Formatting
Are you trying the code on an update form or submission form? the format of the IDs you are referring to on an update/details page is different from submission. What is the link to the page where you have this code on which is throwing an error?
You can try to add a if statement to check and see if it is blank. For instance:
MayMusic got a reaction from viviannaidoo in Copy data from one table to another when a field matches
If that is the case, you can create a TASK instead of a triggered action. The difference is that it will run on a scheduled basis and will move the percent for all matching names.
MayMusic got a reaction from jimarch in Single Sign On - One Table for All Apps
So basically you need to share the member user table among apps. There needs to be another field in this table which is holding the app name. Now the authentication for each app should be based on a view which is filtered by app name field.
MayMusic got a reaction from Henco in Number to Hexadecimal converter
If you are on a submission DataPage and you have an input for the number with the field name: "NumberValue" and another field where you want to store "Hex" you can use the code below in the footer
MayMusic got a reaction from Taneya in Dropdown List
You can change the DataType of the school field in the table from text to List - String and add the school options to the table. Refer to https://howto.caspio.com/tables-and-views/data-types/list/.
Then the user will have the option to select more than one or all
MayMusic got a reaction from MiCro in Rule Help
Let's say if the value in another field is OTHER you want to unhide this field and make it require. Then you need to first add a section and have this field in a section as only one action per field is possible. Two rules you need:
1- Value = OTHER make the field required
2- Value is not equal = OTHER Make it Hidden
So you are doing it the other way around instead of saying
if value = OTHER Unhide
If value is not OTHER Hide
MayMusic got a reaction from molly1990 in Yesterday's Date
Use this code in the footer of the submission page:
MayMusic got a reaction from Shuchi in SQL Filtering with Auth field in where clause not working
If you are using SQL SELECT to read the value you need to use the name of the field form that table not using parameter
so you need to have:
SELECT COUNT(DISTINCT PropertyKeyId) FROM UI_FactTrxn_1 WHERE InvestorUserId = [@authfield:Users_UserId] And you do not have to replace the value with 0 as COUNT returns 0 if there is none.
MayMusic got a reaction from Harbinger in Creating a button in Search and Results DataPage when no records found
Yes all these messages are in the localization you are using for this report page. Create a copy of the localization and under Results Pages >> Messages >> 351 No Records Found >> Add your custom text. You can also add HTML tags for instance <a href="UTL OF THE PAGE"> Add New </a> or you can also have JS.
MayMusic got a reaction from Master in Updating Data inside dropdown
Base all of your dropdowns on a lookup table
This technique requires using a lookup table as the base reference for your dropdowns. Lookup table based dropdowns have several advantages over using custom values. If you do not currently use a lookup table you can find steps to create one here.
Create a Submission Form to your lookup table
First, we are going to create a Submission Form DataPage so users can submit new records directly to the lookup table.
Click New DataPage. By default, the cursor selects Submission Form as the first DataPage type. Click Next.
Select your lookup table as the data source. Click Next.
You can select which fields to be used in your submission form. To select fields, move the fields from the Available Fields list to the Selected Fields list. Because you are submitting to a lookup table, it is likely that there will only be one (or very few) fields. Click Next.
//Replace the FieldName with the Submission form FieldName(parameter name passed when you checked “on exit”.
var new_item = window.opener.document.createElement("option");
// Add new item to the dropdown
//Replace the FieldName with the Original DataPage dropdown FieldName
//Replace the FieldName with the Original DataPage dropdown FieldName
Click Finish to Save Your DataPage.
Deploy Submission Form
1. Select the Submission Form again and click the Deploy button. In order for the script to work, both DataPages must be embedded in webpages with the same domain name. You can make an empty webpage containing only the following HTML:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
CASPIO DEPLOY CODE
2. Replace "CASPIO DEPLOY CODE" with the deploy code of your submission form. If your original form is deployed using the URL deployment method you can deploy the submission form using the same method.
3. Copy the URL of the submission form and save it for use in the next step.
Create a link in your original DataPage
Now in your original form, you add a link that will display a popup window containing the Submission Form from the previous step.
Select the DataPage where you would like to add the link and open the DataPage Wizard by clicking Edit. On the second screen be sure to enable advanced options.
Proceed to the Configure Fields screen. Using the Insert button at the lower right of the DataPage Elements panel, add an HTML block. Go to the Source mode and insert the following link code into the HTML panel:
<a onclick="window.open('DataPageURL','popup','width=307,height=341,scrollbars=no,resizable=no,toolbar=no,directories=no,location=no,menubar=no,status=no,left=0,top=0'); return false">Add Option</a>
Replace the DataPage URL portion with the URL of the first Submission Form. Update the other options in this hyperlink as needed.
To move the link to the same line as the dropdown, select the dropdown DataPage element and go to the Advanced tab. Click the Checkbox for Continue next element on same line.
Click Finish to save your DataPage
MayMusic got a reaction from jasonkaeb in Reset button on Search Form does not work as needed
If you have ajax enabled the reset button would not work and as DevArora mentioned above you need to clear the values with JS
MayMusic got a reaction from paulmurphy in Multiple "Clients" with restricted views/access in an App?
If you would like to receive the value in a submission/update or details page to stamp it to the record then you can change the form element to hidden and receive the parameter from authentication. https://howto.caspio.com/authentications-and-connections/authentication/stamp-a-record-with-user-profile-data/
In report pages to return user-related data https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/