CodePeople2

Hello @metusalem

Thank you for using our plugin!

For all our commercial distributions, the plugin comes with the ability to send users an email copy containing the information collected in the form – including the calculated field results. However, if you want to generate a dynamic PDF file with the submitted data, you will need to upgrade to the Platinum version and activate the “CFF – PDF Generator” add-on.

Please read our blog post to learn how to create dynamic PDF files:

https://cff.dwbooster.com/blog/2020/07/19/pdf-generator

And watch the following video:

https://www.youtube.com/watch?v=TXLMB3_w-Xg

Best regards.

Hello @benlashley80

The commercial editions of the plugin store all data submitted via the form in your website’s database. You can access this data through the “Calculated Fields Form > Entries” menu option (https://cff.dwbooster.com/documentation#check-submissions). This section also allows you to export submissions to a CSV file, which can be used with Excel, Google Sheets, or any other spreadsheet program.

If you want to store the data collected by the form in another database or custom tables, or generate additional files, you can do so using the “cp_calculatedfieldsf_insert_in_database.php” file included with the Developer and Platinum versions of the plugin. For more information, please refer to https://cff.dwbooster.com/documentation#third-party-database.

Finally, if you want to append the data directly into a CSV file instead of doing it manually by pressing a button in the “Entries” section, you can activate the “CFV – Generator” add-on distributed with the plugin Platinum version ( https://cff.dwbooster.com/blog/2020/06/01/csv-generator-google-sheet )

Best regards.

Hello @benlashley80

Your question was how to implement an OR, not an AND, and your code was only checking if the value in type matches any of the fields’ values. If it is the behavior you want to implement, the code is correct. Note that I’m checking the equation structure only, and I don’t know if your fields exist on the form, or what values they have assigned.

Please provide the link to the page containing the form.

Best regards.

Hello @benlashley80

The process is simpler by using the “IN” operation:

(function(){
    for(let i in typedb) {
        if(IN(typedb[i]['type'], [fieldname240, fieldname241, fieldname242, fieldname243])) return typedb[i]['tp'];
    }
    return '';
})()

Learn more about the “IN” operation by reading the “Logical Operations” module documentation:

https://cff.dwbooster.com/documentation#conditions-module

Best regards.

Hello @benlashley80

You should insert a calculated field that does the sum, and then use it in the HTML Content field. For example, if you have the fieldname4 that is a calculated field with the equation fieldname2+fieldname3 The HTML piece of code in the “HTML Content” field would be:

<p>Thank you <span data-cff-field="fieldname1"></span>, your total will be <span data-cff-field="fieldname4"></span>.</p>

Best regards.

Hello @benlashley80

There are no space characters (fieldname243|r). The plugin works as follows:
It takes the equations and replaces the fields’ names with their corresponding values, but preprocesses them first to be used in mathematical expressions, etc. Additionally, the plugin supports the modifiers (the modifiers modify the plugin’s default behavior).

Currently, there are three modifiers:

|r allows you to access the raw field’s value, without preprocessing, e.g., fieldname243|r

|n tells the plugin you are referring to the field’s name directly instead of its value, e.g., ACTIVATEFIELD(fieldname1|n);

|v only supported by radio buttons, checkboxes, and dropdown fields. In these controls, you can decide between submitting the choices’ texts or values, the |v modifier tells the plugin you are referring to the information that would be submitted. If you have configured the field to submit the choices’ texts, the fieldname1|v allows you to access the selected choice text from the equation instead of its value (by using simply fieldname1, you would be accessing the selected choice’s value).

Best regards.

Hello @benlashley80

You must ensure the field is not empty before generating the output:

IF(fieldname243|r, DATEDIFF(TODAY(), fieldname243 , 'yyyy-mm-dd','y') ['years'], '')

Best regards.

Excellent !!!

Best regards.