codepeople

Hello @denba

Thank you very much for using our plugin.

I’m sorry, we can’t reply about that in this forum. We are not allowed to support any customers in these forums and the shortcode for results is a commercial feature.

For pro or commercial product support, please get in touch with us directly on our site. This includes any pre-sales topics as well.

Commercial products are not supported in these forums. We will happily answer this and any other questions you can have on our own site.

Thank you.

Hello @akitaro

I’m sorry, I’ve forgotten the second question.

The option here would be check the field value as part of the onclick event code.

For example, assuming the DGPR field is the fieldname1, and you want to display an alert message when the user presses the button and the fieldname1 field is ticked. In this hypothetical example, you can enter the following piece of code as the button onclick event:

if(getField('fieldname1').val()) alert('the message');

As the code is in another context (it is not an equation) to access the field value you must call the getField operation to get field’s object, and the val method to get its value.

Best regards.

Hello @mate2001

In short, you want the result of the equation be the sum of both numbers, only if both operands are different from zero. In this case, the equation can be implemented as follows:

IF(AND(fieldname1, fieldname2), fieldname1+fieldname2, 0)

And that’s all.

Best regards.

Hello @denba

In the current plugin version, it would require to customize your plugin copy, or emulate the time component with dropdown fields. The plugin includes multiple alternatives to distribute the fields in columns. Please watch the following video:

https://youtu.be/NSac2cAN8RE

For example, assuming that fieldname1 is a date field, fieldname2 is a dropdown list for hours, fieldname3 is another dropdown list for minutes, and fieldname4 is a third dropdown field for seconds.

As part of the equation you can include the piece of code:

let d = CONCATENATE(CDATE(fieldname1, 'yyyy/mm/dd'), ' ', fieldname2|r, ':', fieldname3|r, ':', fieldname4|r);

Now the d variable contains a text with the format “yyyy/mm/dd hh:ii:ss” and you can use it with the Date/Time operations:

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

Best regards.

Hi,

Please update to the latest version of the plugin (#1.4.84 or later) to correct that issue.

Thank you for using the plugin!

Hello @eberkland

Not exactly. The code .prop('checked',true) does not trigger the onchange events required to evaluate the dependencies and the equations. For this reason, the code in the other support thread must call the onchange event directly. The setVal method does both operations. It ticks the corresponding choices and triggers an onchange event at the end of the process.

However, it does not disable the other choices in the checkbox field.

Best regards.

Hello @eberkland

Assuming you have the fieldname1, with two choices, fruits and vegetables, and the checkbox field fieldname2 with the choices bananas, strawberries, carrots, and lettuce. If the user selects fruits in fieldname1 you want to tick the bananas, strawberries choices in fieldname2, carrots, and lettuce choices if the user selects vegetables.

You can insert a calculated field in the form to be used as an auxiliary (you can hide it by ticking a checkbox in its settings), and enter the equation:

getField(fieldname2|n).setVal(IF(fieldname1=='fruits', ['bananas', 'strawberries'], ['carrots', 'lettuce']))

Or if you prefer to implement the equation with function structure:

(function(){
    if(fieldname1=='fruits'){
        getField(fieldname2|n).setVal(['bananas', 'strawberries']);
    } else {
        getField(fieldname2|n).setVal(['carrots', 'lettuce']);
    }
})()

Best regards.