Jump to content


Popular Content

Showing most liked content since 02/18/2018 in all areas

  1. 1 point

    Using Caspio in your business

    Yes there are reseller accounts in Caspio. If you go with corporate you get 400 DPs and you can purchase more along the way if you need to. https://www.caspio.com/pricing/
  2. 1 point

    System Date in View?

    Hi @AussieCaspio, You can create a View which will filter your table with promotion based on start and end date. Here is an example of filter: This article might be useful: https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-filter-data/ Regards, vitalikssssss
  3. 1 point

    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. Format the Field as needed, Go to the Advanced Tab and check “on exit to pass field value as parameter”. Note the parameter name as you will use that name in your Javascript. Click Next again. Now on the last page, replace the success message with a JavaScript. This JavaScript will close the popup window and the new dropdown items will be visible. Go to the Source mode and insert the following JavaScript into the message panel: <script> window.close(); //Replace the FieldName with the Submission form FieldName(parameter name passed when you checked “on exit”. var element_value='[@InsertRecordFieldName]' var new_item = window.opener.document.createElement("option"); new_item.text=element_value; new_item.value=element_value; // Add new item to the dropdown try { //Replace the FieldName with the Original DataPage dropdown FieldName window.opener.document.getElementById("InsertRecordFieldName").options.add(new_item, null); } catch(ex) { //Replace the FieldName with the Original DataPage dropdown FieldName window.opener.document.getElementById("InsertRecordFieldName").options.add(new_item); } </script> 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" "http://www.w3.org/TR/html4/loose.dtd"> <html> <body> CASPIO DEPLOY CODE </body> </html> 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
  4. 1 point
    In your submission or update page for Email field you can select EMAIL special element from Form Element dropdown. To not let user enter numbers To prevent user from entering numbers for First_name field on submission page you can have: document.getElementById('InsertRecordFirst_Name').onkeyup= function(v_e){ v_e = v_e || window.event; if (v_e.keyCode > 47 && v_e.keyCode< 58) { this.value = this.value.substr(0, this.value.length - 1); return false; } }
  5. 1 point
    Howdy Vander. I would suggest adding the InsertAction shown here as a second action of the awards table trigger. This way you aren't cascading triggers, it's all done in one place. Question, are you trying the Milestones to the Awards? If yes that might create some challenges but there are solutions for that also. I hope that helps.
  6. 1 point
    Thanks for the reply. They have just implemented this feature, it works like this: https://blah.caspio.com/rest/v1/views/MyView/rows?q={"pageNumber":2,"pageSize":10}
  7. 1 point
    Hi MattFL, I am afraid that with the current set up and system limitations (API returns maximum 1,000 rows per call) it is not possible to do. As soon as Caspio is continually improving the product and expanding standard feature set, you may visit Caspio Ideabox at http://ideabox.caspio.com and share your idea there.
  8. 1 point
    I tried this code and it worked for me <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var CompanyID = document.getElementsByName("InlineAddRed")[0].value; var Area = document.getElementsByName("InlineAddGreen")[0].value; var CompanyID_Area = CompanyID + Area; alert(CompanyID_Area ); document.getElementsByName("InlineAddallcolor")[0].value = CompanyID_Area; } document.getElementById("Mod0InlineAdd").onclick=concatenate; </SCRIPT>