EmperorFPM

1000 STARS!!

That did it. It now works as I knew it could.

Thanks for your help.

Copied verbatim from the image – no luck

Used a fresh basic WP install with only CF7 and this – no luck

Not sure what else I can, seems like a really good idea for a plugin and I wish I could sort it out.

Thanks for all your help so far

I’ll try a couple more things.

• This reply was modified 1 year, 3 months ago by EmperorFPM.

I ran out of time yesterday but here is live URL for the form

https://financialexaminer.com/test-car-choice/

I’ll say your effort and support get you 5+ stars and I’ll make sure to review the plug-in.

That said it still doesn’t work ??

I’ll keep working on it but not sure what to even look at next.

If I find a solution, I’ll update, if you have any other ideas I’d be appreciative.

it’s showing up on the page and not being executed. I’ve also just discovered another issue. I’m trying to have a user select a Year and then the Models of Cars from that Year will populate the next Select and then from the choice of Models the next Select (Makes) is populated.

Right now using this:

Year of Car [select caryears select2]

Make of Car [select carmakes select2]

Model of Car [select carmodels select2]

[cf7-recordset id=”car-years” type=”database” query=”SELECT DISTINCT year, make, model FROM car_db”]

[cf7-link-field recordset=”car-years” field=”caryears” value=”year” text=”year”]

[cf7-link-field recordset=”car-years” field=”carmakes” value=”make” text=”make” condition=”record[‘year’] == {field.caryears}”]

[cf7-link-field recordset=”car-years” field=”carmodels” value=”model” text=”model” condition=”record[‘make’] == {field.carmakes}”]

All of the models from every make of car is being shown in the last select field.

Do I need to do separate query to keep them isolated to the previous query results?

That is super helpful to know, thank you.

This == {field.caryears}”] isn’t being seen, I tried to span it and use a do_shortcode but those didn’t work

Thanks for the reply, it was actually the value=”year” and text=”year” that were missing and that is why the data was there but wouldn’t display. Didn’t realize it need to match the DB query and not the field.

Here is complete working:

Car Years

[select caryears select2]

[cf7-recordset id=”car-years” type=”database” query=”SELECT DISTINCT year FROM car_db”]

[cf7-link-field recordset=”car-years” field=”caryears” value=”year” text=”year”]

And now I’m trying to get the year to create a database query so I can get the ‘make’ of cars from the ‘year’ entered by user

This plugin is all about up selling or locking away everything useful to force an upgrade. And to add plugins automatically with no permission is horrible. Will never use this or look at it again!

Sure.

An affiliate uses a banner/link provided by me. The User clicks on link and comes to my website and fills out a form. Once that form is submitted it counts as “Sale” and the affiliate gets a payout.

Thanks and sorry I wasn’t clear. I want to POST the data to a 3rd party API.

Thanks for checking that.

This fixed my issue.

added to theme functions.php

add_action( ‘init’, function() { delete_option( ‘schema-ActionScheduler_StoreSchema’ ); } );

Thanks for looking into this.
Here is a couple images for reference: https://imgur.com/a/iRvZWcs

internal dashboard shows a 5 hour time difference
and User “last donated” shows 5 hours ago but was a few seconds before I took the screenshot.

My WP setting are UTC -5 (Uni time now 14:27:54 and local 09:27:54)

Not sure why it’s not syncing up.

Nevermind, I had to deactivate/reactive CF7 in order for it to work. Thanks