Jump to content


Popular Content

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

  1. 1 point

    Automated Email on date

    Hello all, I have been playing around with Caspio and really like what I see! I have several potential projects in mind, but I want to ask about two features I haven't been able to find/figure out. 1) The database will contain information including fields for email address and an expiration date. I would like to automate a process to send an automated email to the email address specified in the record at the 30 day mark prior to the expiration date in the record. The email will contain a link on how to submit a new record. 2) Can I send an automated email with a link to someone to update a particular record, and only that record? (not as important, but would be nice) 3) Can I create a custom html template to display a particular record? On the backend, I would like to export one particular record to a specific format so I can save it as a PDF and print it. If you can point me in the right direction on any of these, it would be great! Thanks!!
  2. 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/
  3. 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
  4. 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
  5. 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; } }
  6. 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.
  7. 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}
  8. 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.
  9. 1 point

    Automated Email on date

    Hello, 1) Caspio does not have the ability to trigger email notifications automatically in Caspio Bridge. Your options would be a) have Caspio professional services hard code the email trigger (at additional cost), b ) use Javascript on a bulk edit form to auto generate the email upon URL open and use Windows task manager to schedule (this option works but a bit cumbersome), or c) use a 3rd party service like Zapier to auto generate the email (setup a Caspio import to trigger a table update, which through Zapier would trigger email notification). 2)Yes, if using bulk edit datapage to trigger emails you could create a calculated field with case statement in the table or datapage to produce the custom URL and use it on the email notification. 3) For custom HTML, you can use a details datapage and setup headers/footers/html block to display html data (just set filter to receive parameter, then add at least one field to display, and you can then hide this unused field (see article https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/).
  10. 1 point

    Add Date to String in Formula

    Hi DesiLogi, You can convert date/time field to a String with the following expression: LEFT(CONVERT(VARCHAR, [@field:Date], 120), 10) Regards, vitalikssssss
  11. 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>