ka2

I apologize for the inconvenience.

The way to disable ajax option in the administrator screen is as follows;
Please change to “Repeater Layout” at the “Data List Format” option in the “General Plugin Settings” on the “CDBT Plugin Options”.

Thank you,

2) について、症状が発生しているページのURLを教えていただけたりしますか？
どのような状況なのか確認してみたいです。

もしURLの開示がこのフォーラム上では都合が悪い場合、support@ka2.orgまでメールいただいても構いません。

ご検討いただけると幸いです。

Thank you for providing.

Well, the CREATE TABLE query has worked correctly.

Therefore, if it does not exist data that matching string as like “profession” in slug column on your “wp_cf_form_entry_values” table, such columns will have null after creating table.

What data have in your “wp_cf_form_entry_values” table?
Also, how do you want to create table and have data?

Please tell me if you like.

Thank you very much for reporting.

Sorry, I think that phenomenon that you said is likely bug occured by the ajax load option. Therefore, you should set the “ajax_load=false” in the shortcode.

Also I’m going to fix about that bug at next version.

Thank you,

Thank you for your inquiry.

In the “cdbt-view” shortcode options, you should set 1 to “Max Rows Per Page”. However, if that table has multiple row (record), it’s displayed the pager or the pagination. If you want to show an unique row only, you should narrow down optimal data by using “Narrow-down Keywords” option.

Also, example of shortcode is as follows:

[cdbt-view table="your_table_name" limit_items="1"]

[cdbt-view table="your_table_name" narrow_keyword="ID:2" limit_items="1"]

Thank you,

I am sorry I haven’t been in touch for a while.

The easiest way to do this, is to modify the table’s column as entry field.
In the modify table tab on the tables management, you should issue a query below.

ALTER TABLE your_table_name MODIFY target_column_name varcahr(255) DEFAULT '';

Note: the column definition depend on your table schema.

Please try it.

Thank you,

I think that’s a very hard thing to do.

Firstly, please allow me to check that my understanding is correct or not.

In summary, do you want to change any entry fields dynamically depending on a value that is choose at the “CLIENTE” field?

If so, I have a good idea.

Firstly, it post once value of “CLIENTE” field by using on change event of JavaScript to self page. The sample JavaScript code is below:

function my_coustom_footer_scripts(){
?>
<script>
$('#entry-data-CLIENTE').on('changed.fu.selectlist', function () {
  var html;
  html += '<form method="get" action="'+ window.location.href +'" id="regenerate" style="display: none">';
  html += '<input type="hidden" name="choose_cliente" value="'+$(this).selectlist('selectedItem').value+'">';
  html += '</form>';
  $("body").append(html);
  $('#regenerate').submit();
  $('#regenerate').remove();
});
</script>
<?php
}
add_action('wp_print_footer_scripts', 'my_coustom_footer_scripts');

Then, you should insert code to get the “CLIENTE” value to your filter hook of “custom_pruebaese_form”. The sample filter hook code is below:

function custom_pruebaese_form ($elements_options, $shortcode_name, $table ){
if ( 'Prueba ESE Formulario' === get_post()->post_title && 'cdbt-entry' === $shortcode_name && 'pruebaese' === $table ) {

  $current_cliente_value = isset( $_GET['choose_cliente'] ) && ! empty( $_GET['choose_cliente'] ) ? $_GET['choose_cliente'] : null;

...

}
add_filter( 'cdbt_shortcode_custom_forms', 'custom_pruebaese_form', 10, 3 );

How is my proposal?
I hope I can be of assistance.

Thank you,

Hi,

Is that a primary key column in your table does not have the attribute of auto_increment, and do you want to use that column as if auto_increment column?

If another columns in that table have no auto_increment, it’s most easy that you will add an attribute of “auto_increment” to already primary key column.

In that case is:

1. Go to the “Modify Table” tab at the “CDBT Tables Management” screen.
2. Choose the table you want to modify, then Click to “To Modify Table”.
3. Please enter to the “SQL Query” as follows:

ALTER TABLE your_table_name MODIFY your_primary_key_column bigint(20) unsigned NOT NULL AUTO_INCREMENT;

4. Click to the “Modify Table Schema”.

A column that has attribute of “auto_increment” is not displayed in the entry forms.

Thank you,