Doubt with CB Query Field

Hello,

I'm going to try to explain my doubt.

I use the CB Query field plugin to show the states, through a query:

SELECT
idstate, state FROM states
ORDER BY states


But now, I need the value of the idstate selected, to do the query of the
cities of this state selected.

The query would be:

SELECT idcity, city
FROM states, cities
WHERE idstate = refstate
AND idpro = SELECTED VALUE IN THE DROP DOWN PREVIOUS
ORDER BY city

This SELECTED VALUE IN THE DROP DOWN PREVIOUS, is there any way to obtain it?

And could you give me a manual or any example, how do it?

Thanks

The query supports substitutions. So you can use [cb_state] for example to check for the selected state. There is no ajax or dynamic reload of the fields edit display though so they'll need to change the state, save their profile, then the new values will show if using a substitution in the where statement of your query. Example as follows.

Hello,

1.
but, is it possible to save the registration form midway during the registration process so that the first field data is saved, but still let the user continue entering data?

2.
And there isn't another way to reload the page when you selected the state, to select the cities?

Thanks.

1.
but, is it possible to save the registration form midway during the registration process so that the first field data is saved, but still let the user continue entering data?

No, not without ajax to save the first field or to render the second field with the first fields value passed to it. None of which is implemented.

And there isn't another way to reload the page when you selected the state, to select the cities?

No.

Hi,

Could you give me any alternative to do this?

Thanks.

The feature you want does not exist in CB nor do we have a plugin to provide it. The alternative is to develop a plugin to meet your needs.