Radio button DS

Hello,

The process is really simple. I will try to describe it with an example.

Assuming your datasource is returning the following pairs of data for the choices:

First Choice:
– Value: 31
– Text: First item

Second Choice:
– Value: 65
– Text: Second item

Third Choice:
– Value: 89
– Text: Third item

And you want tick the second choice by default (when the data be loaded).

In this case you only should enter the value corresponding to the second choice: 65 through the attribute: “Select by default” in the properties of the “Radio Button DS” field, and that’s all.

Best regards.

Hello @hrvan,

The process is very simple. Assuming the field is the fieldname1, you simply should insert a “HTML Content” field in the form with the following piece of code as its content:

<script>
jQuery(document).on('change', '[id*="fieldname1_"]', function(){
jQuery('[id*="fieldname1_"]:eq(0)').prop('checked', true);
});
</script>

and that’s all.
Best regards.

Hello @hrvan,

The process depends of datasource used to populate the field. For example, assuming you are using a database as datasource, and the table’s name is: my_table, the column’s name for values: column_a, and you want populate the text of choices with the text: ‘this text’, the query would be similar to:

SELECT column_a as value, 'this text' as text FROM my_table

I’m sorry, but this question is not specific to our plugin, these are general knowledge about SQL. If you need additional support implementing your specific project, I can offer you a custom coding service from my private website:

https://cff.dwbooster.com/customization

The support service does not cover the implementation of the users’ projects.

Best regards.

Hello @hrvan,

Exactly, the question is about SQL queries, and not the plugin, in the “SELECT” queries if you want the resulting rows include a specif text, instead to use the column’s name, use directly the text, similar to:

SELECT column_name as value, 'this text' as text FROM table_name

In the previous query the values of choices in the “Radio Button DS” field would be values into the column_name column, but the texts of the choices would be: this text

Best regards.

Hello @hrvan,

Not exactly. Please, look the screenshot visiting the following:

https://wordpress.dwbooster.com/customdownloads/2018/01/19/screenshot_ds.png

Pay attention to the properties of the “DS” fields, if you need to enter a custom query, as in this case, you should tick the “Custom Query” option, and enter the query through the “Type the query” attribute.

Best regards.

Hello,

You are not defining the “WHERE” clause in the custom query. The equivalent to the described query is:

SELECT meta_value as value, 'Viza' as text FROM {wpdb.postmeta} WHERE meta_key='viza_1' AND post_id=<%fieldname2%>

and that’s all.
Best regards.