Saving user selection from HTML shortcode to database

Hi @atebol

Are you able to export your:
– form
– full custom snippet you use
and upload to google drive or dropbox so that we could take a closer look at this?

As for Visibility you can update select field options for the backend also through https://wpmudev.com/docs/api-plugin-development/forminator-api-docs/#method-update_form_field. Once values are rendered can be used for conditional logic as well.

Kind Regards,
Kris

Hi @atebol

Thanks for response!

I’ve checked what you shared and I admit I’m even more confused now. Let’s take a step back then and try to “break that down” a bit.

1. Initially you reported that the hidden field contains shortcode itself instead of its output.

i was wondering where this {filter_cm_tooltip_parse} shortcode is coming from since you didnt’ specify it and I finally found it. it’s a shortcode that is a “custom wrapper” for a {cm_tooltip_parse} shortcode of CM Tooltip plugin and, apparently the code that makes it was provided by us.

However, I’m not sure what’s the goal here. This shortcode is meant to display some sort of a tooltip and it will not work in submissions anyway. Furthermore, the code that you shared in initial post uses “forminator_custom_form_submit_field_data” forminator filter – this is a filter that’s applied “in background” upon submission. It doesn’t “display anything” and cannot make any JS to be executed and/or apply any front-end CSS to the submission data (and original cm_tooltip_parse seems to depend on JS or CSS if I correctly understand).

Ultimately, I’m not sure what’s the goal of trying to add a tooltip into a hidden field data, especially “upon submission”.

Would you explain this a bit more, please?

2. The custom code that you shared recently

This code is meant to fetch data from a 3rd-party/external database, from specific tables. It needs to have DB connection configured and use correct DB tables names. It’s my understanding that you did correctly configure DB connection (just removed from shared code – which is fine) but

– are tables names correctly set in these lines of the code?

$result = $conn->query("SELECT wdt_ID, clientname FROM wp_wpdatatable_2 ORDER BY clientname ASC");
             $result2 = $conn->query("SELECT wdt_ID, type FROM wp_wpdatatable_3 ORDER BY type ASC");
             $result3 = $conn->query("SELECT wdt_ID, status FROM wp_wpdatatable_4 ORDER BY status ASC");
             $result4 = $conn->query("SELECT wdt_ID, name FROM wp_wpdatatable_1 WHERE activeuser = 1 ORDER BY name ASC");

– are select field IDs configured to match form select fields in these lines?

private $field_id   = 'select-3';
        private $field_id2   = 'select-4';
        private $field_id3   = 'select-5';
        private $field_id4   = 'select-2';

– and how does it related at all to the initial question about shortcode?

Please advise!

Kind regards,
Adam

Hi @atebol

Thanks for response!

I’ve tested this and you’re right – it does result in error. I’m pretty sure this is due to the changes in plugin that would make this code require some modifications (note that it’s a custom code) but I wasn’t able to get it solved yet.

I need to consult it with out developers so I’ve asked them directly to check it again and see if they come up with necessary modification.

I’d appreciate some patience as they are dealing with a lot of complex tasks on daily basis and their response time might be a bit longer than ours here. But we’ll update you here again as soon as we got feedback on this.

Kind regards,
Adam

Hi @atebol

It seems there’s been a bit of misunderstanding on our end, I’m sorry about that.

When asking our developers for help, I have earlier modified the code slightly because I don’t have the same setup/db-structure. Apparently my colleagues didn’t notice that when sharing updated code with you. Once again, I’m sorry about that.

Could you give that code another try, please?

Just make sure to change this part

// $conn = new mysqli('localhost', 'DB_NAME', 'DB_USER', 'DB_PASS') or die ('Cannot connect to db');

            // $result = $conn->query("SELECT wdt_ID, clientname FROM wp_wpdatatable_2 ORDER BY clientname ASC");
            // $result2 = $conn->query("SELECT wdt_ID, type FROM wp_wpdatatable_3 ORDER BY type ASC");
            // $result3 = $conn->query("SELECT wdt_ID, status FROM wp_wpdatatable_4 ORDER BY status ASC");
            // $result4 = $conn->query("SELECT wdt_ID, name FROM wp_wpdatatable_1 WHERE activeuser = 1 ORDER BY name ASC");
			
			
			$result['wdt_ID'] = 1;
			$result['clientname'] = "Client 1";
			$result2['wdt_ID'] = 2;
			$result2['type'] = "Type 2";
			$result3['wdt_ID'] = 3;
			$result3['status'] = 'Status 3';
			$result4['wdt_ID'] = 4;
			$result4['name'] = 'Name 4';

to this

$conn = new mysqli('localhost', 'DB_NAME', 'DB_USER', 'DB_PASS') or die ('Cannot connect to db');

$result = $conn->query("SELECT wdt_ID, clientname FROM wp_wpdatatable_2 ORDER BY clientname ASC");
$result2 = $conn->query("SELECT wdt_ID, type FROM wp_wpdatatable_3 ORDER BY type ASC");
$result3 = $conn->query("SELECT wdt_ID, status FROM wp_wpdatatable_4 ORDER BY status ASC");
$result4 = $conn->query("SELECT wdt_ID, name FROM wp_wpdatatable_1 WHERE activeuser = 1 ORDER BY name ASC");

replacing DB_NAME, DB_USER and DB_PASS with correct credentials of your DB.

Also in this part make sure that form ID and fields IDs are correct:

// User defined settings
        private $form_id    = 2153;
        private $field_id   = 'select-3';
        private $field_id2  = 'select-4';
        private $field_id3  = 'select-5';
        private $field_id4  = 'select-2';

Kind regards,
Adam

• This reply was modified 1 year, 4 months ago by Adam - WPMU DEV Support. Reason: db creds