cheonsa

Hi All, 
I was able to make a workaround not to include blank fields in the Automatic email using Calculated Value. 
I used Virtual fields in this example. Here is the formula:
CASE WHEN '[@cbParamVirtual1]' = '' THEN '' ELSE 'Virtual 1: [@cbParamVirtual1]' END + CASE WHEN '[@cbParamVirtual2]' = '' THEN '' ELSE ' Virtual 2: [@cbParamVirtual2]' END + CASE WHEN '[@cbParamVirtual3]' = '' THEN '' ELSE ' Virtual 3: [@cbParamVirtual3]' END + CASE WHEN '[@cbParamVirtual4]' = '' THEN '' ELSE ' Virtual 4: [@cbParamVirtual4]' END You can also test this DataPage. I did not hide the Virtual field 5 for the sake of testing.  You may hide it under the Advanced tab. 

Then, on the Email options, use this VirtualField5.

Hope this helps. 
 
Cheers! 

Hi @IamBlossom, 
For File DataTypes, you need to use SQL's "DATALENGTH" to measure if the field has content or not. It is a behavior that NOT NULL or IS NULL will not work for File Datatype.
Use this instead:
CASE WHEN DATALENGTH([@field:Images]) = 0 THEN 'No image attached' ELSE 'Image available' END
 
Hope this helps!

Hi @Leon13,
You may remove the open and close symbol "<>" and insert "&nbsp;" instead. 

Hi @roattw,
If you select a field in the table, Custom option will not be available. It is present in Totals and Aggregation if you click on the plus button. Also, picker button is not available in Pivot Table. 

Hi @roattw,
You can use #inserted in the Select From block instead of the Table (Patients_Encounters_Pre121219). If you use the Table itself, every time the Triggered Action runs, it will send an email to all records where Pending_Info is equal to "Y".
You can refer to this video for more information:
https://www.caspio.com/webinars/send-sms-emails-using-triggered-actions/
 
Happy Holidays!  
 
-kristina 

Hi @roattw,
Actually, you can use Pivot table to achieve your desired Report. 
You can use Totals and Aggregation under values and add custom formula. 


This will be the result

Cheers!
-LittleMsGinger

Hi @Yusuf,
I suggest that you review this forum post: 
I tried this solution on my end and it works!  
 

Hi @Johnn,
You can use FormSubmitted event handler. I saw it in the howto article: https://howto.caspio.com/datapages/ajax-loading/
<script type="text/javascript"> document.addEventListener('FormSubmitted', function(event) { alert('Submitted'); }); </script>  

Hi @wvantongeren,
Just to give you an update regarding this, GetUTCDATE function is no longer supported in Calculated Values and Calculated Fields since the last Release 19.0. Use SysUTCDateTime() to get the UTC date. You may refer to this link for other impacted areas last release: https://howto.caspio.com/release-notes/caspio-bridge-19-0/19-0-impacted-areas/
 
-kristina

Hi @VA123,
You can try to use my code below, I've created a Submission form with two text box. If you have inputted 'ABC' on the first text field and 'XYZ' on the second field it will throw an error message. Else the form will be submitted. This is the deployed URL so that you can see how it works.  https://c5eib829.caspio.com/dp/d90b6000106528eabab84e64b6ea

This is the code that I've formulated, I think you can use the code below, you will just need to change the ID of my text box, to the ID of your fields in your DataPage.  
<script> document.querySelector('#caspioform').onsubmit = function(e) { e.preventDefault(); input1 ="ABC"; // Just replace the ID of your fields in document.getElementById("ID of your field").value; var input1= document.getElementById("InsertRecordValue1").value; var input2= document.getElementById("InsertRecordValue2").value; if (input1 =="ABC" && input2 =="XYZ" ){ alert('You cannot have ABC in the first field, and XYZ in the second field'); } else { this.submit(); } } </script> I hope this helps.
Regards,
TsiBiRu

Hi @QueenB,
 
By default, computer browsers has an ability to translate the language of the pages automatically. 
One other possible solution is to create different DataPages for different Languages. Then, you will have an HTML block with a link inside that will redirect to the other DataPage based on the selected language.
Hope this helps.
 
-kristina

Hi @jafranklin77,
 
I found another forum post that is quite similar to your inquiry. You can check it here: 
 
 
Thanks.
 
-kristina

Hi @jafranklin77,
 
You may also check the solution provided in this link: 
 
 
Hope this helps. 
 
-kristina

Hi @Geekless,
 
Just to give an update, we have a new feature which is Task. Tasks are operations that you can create in your application and run them manually or automatically based on a predefined schedule. 
On your table, you must have an additional field and set the DataType to Timestamp. This should stamp on Update. 

 
On your Tasks, the record will delete if Item is equal to "FFO" and Current date is equal to Item_Updated plus your XXXX days. Just like the screenshot below:

You can run the task daily so it will check if the record meets the condition. For more information about Tasks, please refer to this link: https://howto.caspio.com/tasks/
 
Hope this helps.
 
-kristina

Hi @Hencoco,
 
 
In order to extract the time from a Timestamp, you need to use a formula field and use functions like SELECT convert(varchar(8), getdate (), 108) . However, this will be converted as a String and you cannot filter the time with a String DataType. 
 
What you can do is to get only the hour using this function: Datepart(hh,[@field:time]) It will return as an integer. 

On your Reports DataPage, you can use that formula field as search criteria. You can set it to Dropdown then use custom Value. 

 
For more information, you can check these links: https://howto.caspio.com/function-reference/
https://stackoverflow.com/questions/12354699/time-part-of-a-datetime-field-in-sql
 
Hope this helps.
 
-kristina

Hi @bbeshlian,
 
If you want to submit data from a single submission form to two separate tables, Triggered Action is what you need. 
 You may refer to these links for more information about Triggered Actions: https://howto.caspio.com/tables-and-views/triggered-actions/
 
 
Hope this helps.
 
-kristina

Hi @dmyoungsal,
 
You can also change the width of your Tabular Report on the Style Tab.
Edit the Style you are using for that DataPage.  Choose Table Layout under Results Page then look for Data Cells. Indicate the Cell width based on what you prefer.

 
You can try to preview it to see the changes. 
 
Hope this helps.
 
Regards,
kristina

Hi @dmyoungsal,
 
I understand that you want to display the field AmtPaid as currency on your DataPage. You can go to your Report DataPage > Configure Results Page Fields. 
You can customize your field based on your desired display. However, you cannot change it on your submission form. 

 
Regards,
kristina

Hello @Watusi,
 
You cannot display the value of the field in Details Page if it is set to PageViewIncrement. However, you can insert a calculated field and pass the value to it. Just like this: 

 
Hope this helps.
 
Regards,
kristina

Hi @Role21,
 
Thank you for your response. You can concatenate fields using this formula. You need to convert the DataTypes of your fields to varchar using CAST  function. You can refer to this link: https://howto.caspio.com/function-reference/

 
Hope this helps,
 
Regards,
kristina

Hi @QueenB,
 
Just to clarify your inquiry, you want your reports page to be updated automatically after submitting an entry in a pop-up window without reloading? As of now, it is not yet possible with the current platform. The Ajax functionality inside Caspio operates when submission form and reports are on the same page. 
You can check this forum thread and try this workaround instead.
 
 
For your another question, you can change the location of your popup window by changing the values of the left and the top position. Provided below is a screenshot for your reference. 
 

 
I hope it helps.