Search the Community

Hi everyone, Just wanna share this method I learned when I needed to download the logs Go to preferred logs Select the first cell of your first log record. Navigate/scroll to the preferred range of your last log record. Press and hold the shift key, and select the last cell of your last log record. Right-click on the highlighted log records and click Copy. Open a worksheet application. Paste the copied log records. Keep in mind that only the data are copied and not the column header titles. You may need to type it manually. Cheers!

Hi Caspians, I just wanted to share the additional info about how to successfully verify domain: https://howto.caspio.com/verified-email-and-domain/verify-domain/ 1. Go to Account Settings, click on Email tab and under Email addresses and domains 2. For an unverified domain, click on Unverified Domain and you will be presented with TXT and CNAME records for that domain. 3. Copy the TXT record : caspio_133.yourdomain 4. Go to https://mxtoolbox.com/SuperTool.aspx , paste the TXT record and choose TXT Lookup, and click on TXT Lookup: 5. Do the same thing for CNAME, copy it from your account and paste to the search, but choose CNAME Lookup. 6. If it says 'DNS record not found' and you already contacted your DNS provider and added records, you can check if you added them correctly, because some Hosts automatically appends domain name to TXT and CNAME records, so they don't require formatting to be like this: cas-k1._domainkey.yourdomain CNAME dkim1.caspio.com but this one: cas-k1._domainkey CNAME dkim1.caspio.com And for TXT record just this: caspio_100 Providers that automatically add those are GoDaddy, Squarespace, Namecheap. 7. If you are not sure if your Host automatically appends domain by again going to https://mxtoolbox.com/SuperTool.aspx, and using CNAME Lookup, you will see who is you DNS hosting provider: Then, you can search online for how to add records in this particular DNS.

Hello, I have created an email task that I can run on demand to send me information (in this case, student rosters) and it works in that it sends me the requested data. My question is, is there a way to change how the data is sorted on the emailed report/table variable? I was hoping it would sort in the field order of the table variable (see screen capture) but the email is coming through with the data being sorted by LastName. Do we have any control over how the data is sorted in table variables in tasks? thanks!

Hello, I have created a task that runs on a daily basis to send emails to records in a table that meet a specified criteria. I could have a user with the same email address that has multiple records in the table, but each record is slightly different. So they are not unique records, but the same email address is utilized. Is there a way to prevent this daily task from sending multiple emails to the same address even though the records are slightly different? I have tried using the "Select Distinct" From function, but I believe this only works if the entire record is unique. I would like a maximum of 1 email to be sent to 1 unique email address? Can this be done in the single task? Thank you.

Hi Caspio newbie here! I'm trying to do email verification, most of it works fine but the only way to change the verification status to yes is to manually run the datapage I created called email_verification. the email sends okay and the link copies the GUID but it doesn't change the field status. I tried copying the script on the help page to get automatic updating but it doesn't appear to work....my code is as follows <script> document.getElementById('caspioform').onsubmit = function (){ document.getElementById('[@field:Email_Verified^]').checked="y"; } </script> any advice much appreciated Ian

Is it possible to have a different display name shown in the TO field of an email in a Task or Triggered action. For instance, when you set the TO field to info@acme.com the recipient will see "info" as the name of sender of the email. I would instead like the name to be show as Acme Info. In Outlook, this is done by prefacing the email with the user name like: <Acme Info> info@acme.com. But, in looking around, and testing some different syntax, I can't find anything similar for the TO field in Caspio. Any ideas are welcome.

Hello, Is it possible to make the "FROM" field in a Send Email Task a data field? Or can it only be text? When I try to drag a data field it doesn't give the option to connect. I would like to set the "FROM" field to a text field which contains an email address (this Field is used in the "REPLY TO"). Thanks

Hi, I have a Calendar/Tasks table that stores a date for either an appointment or a task due date. I need to add a few functions and was hoping someone might have an idea of the best way to do this: 1) I need to add a Time selection for a calendar event. Meaning the user selects a date like normal (using the date picker) to put into a date/time field (the 'Event_Date' field in this case) but ALSO can select a time for the event (like a normal calendar like iCal or Google Cal). I know I can create a text field and use a lookup table for all the times (like 2pm, 2:15pm, 2:30pm, 2:45pm, etc.) and store it that way. My question is, can I use a text field that stores a time like this (i.e. "2:45pm") to perform calculations in a formula to get how many days/hours/minutes the current date/time is from that stored date/time? Or does that time data need to be in a specific format or included in the 'Event_Date' value (which is a date/time field). 2) What I'm trying to do is allow the user to do something like set an appointment for a date/time like 4/15/2020 1:30pm and also select a 'notify me' value like "2 days before" or "3 hours" before and then use the Automated Tasks feature to send an email/sms reminder to the user. 3) The last issue is how to store the date/time of the event because Tasks runs on UTC time and my users are all over the globe. So if a user in California puts in "4/15/2020 1:30pm" it's not the same date/time value as someone in Australia, in terms of the Tasks trigger firing. Maybe convert the users local time to UTC after they input it? Not sure of the best approach but to the user, it needs to be viewed/entered as local time (not UTC values) so it's understandable. I wish Caspio had a full calendar like this, built in, as these features are an integral part of most user needs. But if I can build it myself that'd still be great. The first 2 issues to me are the most important, though, so if anyone has some advice on this, or how to get the result I need (a normal calendar with times and notification choices) I'd really appreciate it.

How would I grab all the text in an email address BEFORE the @ sign? I am trying to create a login address that matches our other systems. But I cannot figure out how to get the SUBSTRING of just the front of the email address. For example: If the email address were MMouse@business.com, then I would want to create a USER_NAME variable that is just MMouse. Any suggestions?

Hello ~ I'm trying to send an email via task and its contents are table records by using a table variable. The email in Outlook has borders and arranged neatly, however, the email in Gmail is not pleasing to the eyes as it is not properly displayed and has no borders. Please see the image below. Any advice or tricks on how to insert a border and make them properly aligned?

Hi I have built a simple order tracking app and I want to send email notification to the users every time the status is changed. The problem is that I have multiple status for the orders. Here is a sample of my table records. As you can see, I have "Placed" ,"Picked up" , and "Delivered" status. I have a couple more but the idea is that for each of these status, I want a different email message or content sent to the email address of the user. Currently, I am only using acknowledgement emails so the users will receive an email upon placing an order. Is there a way to do this? Thanks in advance. ~Hexy

I’m trying to create something similar to websites that has a link that automatically opens a mailing app and already has a to address. Is this possible with Caspio? I want it to appear at the bottom of my DataPage. Any suggestion is much appreciated. Thanks!

Is there a way to preview HTML email in trigger without enabling it and sending the email?

Is it possible for automated emails to be sent encrypted? Although the site pages are encrypted, I am getting a warning on receipt of a Password Recovery email (via Gmail) that "Caspiomail.com did not encrypt this email".

I'm going to try to be as clear as possible with this question by laying out the steps and the pieces I'm missing from this operation: 1. A user submits a bid request using the forms on a data page I have created. ( This page is built) 2. An email is generated to vendors (users) that have requested to be notified when a bid is placed. This email will contain some of the fields but not all of the fields from the datapage. (haven't figured out how to configure the submit button above) Thanks all. Becca

hi, I need to change my email. How can I change it? If anyone know, let me know, please., xtrasize

I'm in the brainstorming phase. Members of our staff would like to send emails out to our clients via their email application of choice-- like Outlook, etc. I have a table of 20-400 clients that includes email address information. Any ideas on how I can get those email addresses inside a "To:" field and send out an email? I'm open to exploring Caspio doing this for me but I understand that might not be possible due to inherent anti-spamming design. I'm also concerned with data usage in Caspio. Note: I have wondered about using Javascript to copy email to the system clipboard but this doesn't see like good practice, and I'm only a novice JS user at this point. That said, this post got me thinking more on that: <button id="demo" onclick="copyToClipboard(document.getElementById('demo').innerHTML)">This is what I want to copy</button> <script> function copyToClipboard(text) { window.prompt("Copy to clipboard: Ctrl+C, Enter", text); } </script>

I am using the standard Password Reset datapage. The Email page requires a fixed 'from' email address to be used for all reset requests. I would like to be able to change this 'from' address according to the type of user requesting it. It looks as if Caspio used to allow this programmatically in earlier releases, but it does not appear possible now. Can anyone tell me if there is there still a way to do this?

I am looking for a way to have employee data with a due date that is autopopulated, then it send an automatic notification 30 days before the due date. There doesn't seem to be a away to have auto emails send without interaction/modification with the data. I need it to run in the background without my assistance.

How can I only include non-blank values in email body?

I wrote this simple code which takes in parameters from the database Caspio to create a simple table. I just want this table to remove all fields which are empty. Since email servers do not run javascript, what is the best way to hide the rows which are empty (the paramters such as @field:Facility is not filled out). Thanks! I've also added the code: <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <style type="text/css"> tr:nth-child(even) { background-color: #D3D3D3 } </style> </head> <body> <table class="Form" border="5" width="95%" cellpadding="10"> <thead> <tr> <th colspan="2">&nbsp; <h3>[@field:TestOrder] - [@field:Facility]</h3> </th> </tr> </thead> <colgroup> <col width="250" /> <col width="750" /> </colgroup> <tbody> <tr> <th>FIELD</th> <th>RESPONSE</th> </tr> <tr align="LEFT"> <td>Facility :</td> <td>[@field:Facility]</td> </tr> <tr align="LEFT"> <td>Patient ID :</td> <td>[@field:PatientID]</td> </tr> <tr align="LEFT"> <td>First Name :</td> <td>[@field:PatientFirst]</td> </tr> <tr align="LEFT"> <td>Last Name :</td> <td>&nbsp;</td> </tr> <tr align="LEFT"> <td>Date of Birth:</td> <td>[@field:DateOfBirth]</td> </tr> <tr align="LEFT"> <td>Gender :</td> <td>&nbsp;</td> </tr> <tr align="LEFT"> <td>Primary Phone :</td> <td>[@field:PrimaryPhone]</td> </tr> <tr align="LEFT"> <td>Secondary Phone :</td> <td>[@field:SecondaryPhone]</td> </tr> <tr align="LEFT"> <td>Emergency Contact :</td> <td>[@field:EmergencyContact]</td> </tr> <tr align="LEFT"> <td>Emergency Number :</td> <td>[@field:EmergencyNumber]</td> </tr> <tr align="LEFT"> <td>Patient Address :</td> <td>[@field:PatientAddress]</td> </tr> <tr align="LEFT"> <td>City :</td> <td>[@field:City]</td> </tr> <tr align="LEFT"> <td>State :</td> <td>[@field:State ]</td> </tr> <tr align="LEFT"> <td>Zip Code :</td> <td>[@field:ZipCode]</td> </tr> <tr align="LEFT"> <td>Special Instructions :</td> <td>[@field:SpecialInstructions]</td> </tr> <tr align="LEFT"> <td>Primary Insurance :</td> <td>[@field:PrimaryInsurance]</td> </tr> <tr align="LEFT"> <td>Primary Subscriber ID :</td> <td>[@field:PrimarySubscriberID]</td> </tr> <tr align="LEFT"> <td>Primary Subscriber Relationship :</td> <td>[@field:PrmarySubscriberRelationship]</td> </tr> <tr align="LEFT"> <td>Secondary Insurance :</td> <td>[@field:SecondaryInsurance ]</td> </tr> <tr align="LEFT"> <td>Secondary Insurance ID :</td> <td>[@field:SecondaryInsuranceID ]</td> </tr> <tr align="LEFT"> <td>Secondary Subscriber Relationship :</td> <td>[@field:SecondarySubscriberRelationship ]</td> </tr> <tr align="LEFT"> <td>Diagnosis :</td> <td>[@field:Diagnosis]</td> </tr> <tr align="LEFT"> <td>Other Diagnosis :</td> <td>[@field:OtherDiagnosis]</td> </tr> <tr align="LEFT"> <td>Physician Name :</td> <td>[@field:PhysicianName ]</td> </tr> <tr align="LEFT"> <td>Other Physician :</td> <td>[@field:OtherPhysician]</td> </tr> <tr align="LEFT"> <td>Physician Phone :</td> <td>[@field:PhysicianPhone]</td> </tr> <tr align="LEFT"> <td>Physician Fax :</td> <td>[@field:PhysicianFax]</td> </tr> <tr align="LEFT"> <td>After Hours Phone :</td> <td>[@field:AfterHoursPhone]</td> </tr> <tr align="LEFT"> <td>Test Order :</td> <td>[@field:TestOrder]</td> </tr> <tr align="LEFT"> <td>Test Duration :</td> <td>[@field:TestDuration]</td> </tr> <tr align="LEFT"> <td>Holter Performed :</td> <td>[@field:HolterPerformed]</td> </tr> <tr align="LEFT"> <td>Holter Test Order :</td> <td>[@field:HolterTestOrder]</td> </tr> <tr align="LEFT"> <td>Holter Duration :</td> <td>[@field:HolterDuration]</td> </tr> <tr align="LEFT"> <td>Previous Holter Date :</td> <td>[@field:PreviousHolterDate]</td> </tr> <tr align="LEFT"> <td>Requested Start Date :</td> <td>[@field:RequestedStartDate]</td> </tr> <tr align="LEFT"> <td>Receive Monitor :</td> <td>[@field:ReceiveMonitor]</td> </tr> <tr align="LEFT"> <td>Recorder ID Number :</td> <td>[@field:RecorderIDNumber ]</td> </tr> <tr align="LEFT"> <td>H_P :</td> <td>[@field:H_P]</td> </tr> <tr align="LEFT"> <td>Upload HP :</td> <td>[@field:UpploadHP]</td> </tr> <tr align="LEFT"> <td>Authorize :</td> <td>[@field:Authorize]</td> </tr> <tr align="LEFT"> <td>Submit :</td> <td>&nbsp;</td> </tr> </tbody> </table> </body> </html>

Hello, Any suggestions how could the following be done! I would like to use information from two tables First table (Orders) contains Customer_Email and Product_ID (Filled automatically using Zapier Integration) Second Table (Products) contains Product_ID and Product_URL When a new order is made, an email message should be sent to the customer’s email contains the related Product_URL Note: Zapier does not read Capsio Views also does not update a table

I have an auto-generated email working on my datapage submission form. The table that the form is drawing from is using the unique identifier (Employee_ID) to track the employee that is logging or entering the item in the form. I would like for the employees name to be displayed on the e-mail, so the recipient knows who the email is coming from. I see that I can choose from any data source field that is on the original table and insert that into the subject or into the body of the email. The problem is that when I insert the only option that makes any sense (Employee_ID) the email is sent with the number rather than the employee name. How can I get the email to display the name? I have the same issue with the Job_ID. I would like to also include the job name. Notes: I've already created a relationship and stated to display the name rather than the ID. Thanks!!!! e-mail Field.docx Update: I was able to solve the employee ID by inserting a hidden virtual field into the page, and then entering that data source. Since that came from the authentication table, it was available. I'm still at a loss for how to insert the Job name in lieu of the Job_ID.

I've found a number of sort of related posts on this but nothing exact that I need. I have a tablular datapage with an internal Details page option that sends an Acknowledgement email for Update/Insert records. Works well except I need the user to be able to 'choose' whether to send the acknowledgement (or notification) email by checking a virtual field (check box). This is so an email doesn't go out every single time there's an edit- it only needs to go out when the users decides to by checking the virtual field. I'd like to possibly be able to use something like this on: -and Inline Insert of a tabular datapage (though I don't think it could be virtual field then, perhaps I could put a check box in the data source table) -a Bulk Edit popup But the Details form of a tabular datapage is the first place I need to start. This seems like it should be a standard feature of CB because email notifications shouldn't go out every time an edit is made unless desired. Any help on this would be great- thanks.

I have a form that can be for two separate but related cases. Based on the case selected, certain fields are or are not hidden. So in each case there is a section that does not apply. Is there a way to conditionally show parameters in the auto emails based on which radio button is checked? Essentially mimicking the rules of the form? Or, probably easier, is there an easy way to include it all in the email but hide any fields that are left blank? And not based on any checkbox, but simply if the field is blank, do not show it in the email. Also, I already am using this script for phone #s on the form, in case this affects anything. Thanks! <SCRIPT LANGUAGE="JavaScript"> function f_a(v_id) { return document.getElementById(v_id); } f_a('InsertRecordSchool_Contact_Phone').maxLength = 14; f_a('InsertRecordSchool_Contact_Phone').onkeyup = function(v_e) { v_e = v_e || window.event; if (v_e.keyCode >= 65 && v_e.keyCode <= 90){ this.value = this.value.substr(0, this.value.length - 1); return false; }else if (v_e.keyCode >= 37 && v_e.keyCode <= 40){ return true; } var v_value =(this.value.replace(/[^\d]/g, '')); if (v_value.length==7) { this.value = (v_value.substring(0,3) + "-" + v_value.substring(3,7));} else if(v_value.length==10){ this.value = ("(" + v_value.substring(0,3) + ") " + v_value.substring(3,6) + "-" + v_value.substring(6,10)); }; } </SCRIPT>