Forums

Hello

I have following situation:
Using a form “addresses” users can store two addresses: private and business.
A dropdown menu allows them to define what address will be the main address.

In database table chrono_chronoforms_data_form-demo I have columns
user_id
phone_ private
phone_business
city_private
city_business
main_address

Field main_address contains either value 1 or 2.
Value 1 = main address is phone_private and city_private
Value 2 = main address is phone_business and city_business


On front page I have another form called “subscription”. It contains two textfields:
phone
city
Now the user logs in and opens this form.

Depending on if the database field “main_address” contains 1 or 2, the form should automatically load the correct phone number and city.


My approach is as follows:

Add a read_data action and receive value of field main_address.
In the “found” section I add action “Events switcher”.
I add events 1 and 2.
In event 1 I add a read_data to get value of field phone_private and city_private.
In event 2 I add a read_data to get value of field phone_business and city_business.

The debugger gives me this:
​

Array
(
    [read_data1] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `Address1`.`main_address` AS `Address1.main_address` FROM `chrono_chronoforms_data_form-demo` AS `Address1` WHERE `Address1`.`user_id` = '610' LIMIT 100;
                )

            [var] => Array
                (
                    [Address1] => Array
                        (
                            [main_address] => 1
                        )

                )

        )

)

​

​
​
Now the problem I have: Even if value 1 is read from main_address, CF does not execute the action in “event 1”. No matter if I add a read_data, a custom code or a debugger. Nothing happens.

What goes wrong here?

Thanks.
Patrick

I got one step further:
​
In the Events switcher and there in the data provider field I replaced {data:main_address} with
{var:read_data1.Address1.main_address}
​
Now I get the data from data_read action in event 1.
​
But I don't know how to load the pone number and city into the form fields.
In the view section it can be done by entering following code into field "value":
​
{var:address1.Address_Private.phone_private}
​
This works!
​
But I need this dynamically, because for the phone field it either can be
{var:address1.Address_Private.phone_private}
or
{var:address2.Address_Business.phone_business}
depending on if main_address is 1 or 2.

The same goes for the second textfield "city".
​
How can I get correct data?
​
Thanks.
Patrick

Hi Patrick,
​
Personally I'd probably use one query that gets both addresses, then use PHP to add the correct one to the form data.
​
Bob

Hi Bob and thanks
​
OK, so my approch might not be the correct one...🙂
​
Inside the events switcher I have given both read_data same name and same model name. This allows me to use this:
{var:user_address.Address.phone_private}
{var:user_address.Address.city_private}
​
Now only phone_private and city _private should be replaced by a dynamic value. I did try
{var:user_address.Address[1]}

but this is not working.
​
It works if I add this to the form field:

​
But if this approach is not the correct way to do this, I'll switch to a PHP solution.
Any suggestions?
​
​
Patrick

Hi Patrick,
​
If you have it working then stay with that. I don't think that there is one *right* way to do this.
​
Bob

Hi Bob
​
Yes, many ways lead to Rome...
​
Nevertheless I did try using PHP:
​
I use a read_data to get all data:
​

Array
(
    [read_data1] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `Address1`.`aid` AS `Address1.aid`, `Address1`.`user_id` AS `Address1.user_id`, `Address1`.`created` AS `Address1.created`, `Address1`.`modified` AS `Address1.modified`, `Address1`.`phone_private` AS `Address1.phone_private`, `Address1`.`phone_business` AS `Address1.phone_business`, `Address1`.`city_private` AS `Address1.city_private`, `Address1`.`city_business` AS `Address1.city_business`, `Address1`.`main_address` AS `Address1.main_address` FROM `chrono_chronoforms_data_form-demo` AS `Address1` WHERE `Address1`.`user_id` = '610' LIMIT 100;
                )

            [var] => Array
                (
                    [Address1] => Array
                        (
                            [aid] => 1
                            [user_id] => 610
                            [created] => 2019-10-12 04:47:46
                            [modified] => 2019-10-12 05:44:19
                            [phone_private] => 111 111 11 11
                            [phone_business] => 222 222 22 22
                            [city_private] => Berlin
                            [city_business] => London
                            [main_address] => 2
                        )

                )

        )

)

​
Then I use this PHP code:

$main_address = $this->data("main_address", "");

if ($main_address == 1) {
$phone = $this->data("phone_private", "");
}
if ($main_address == 2) {
$phone = $this->data("phone_business", "");
}

echo $phone;
echo "Test";
?>

​
But I can't get value of

$this->data("main_address", "")

The "Test" is echoed, so PHP is executed.
​
Why is $main_address empty and how can I get $phone into the value field in the view section?
​
Patrick

It works using this code:
​

<?php

$main_address = $this->get("read_data1.Address1.main_address", "");
$phoneP = $this->get("read_data1.Address1.phone_private", "");
$phoneB = $this->get("read_data1.Address1.phone_business", "");
$cityP = $this->get("read_data1.Address1.city_private", "");
$cityB = $this->get("read_data1.Address1.city_business", "");

if ($main_address == 1) {
$phone = $phoneP;
$city = $cityP;
}

if ($main_address == 2) {
$phone = $phoneB;
$city = $cityB;
}

echo $phone;
echo $city;

?>

​
Last step: How can I load $phone and $city as value into the form fields?

<php echo $phone; ?> 

​
is not working.
​
Thank you.
​
Patrick

Hi Patrick,
​
Use

$this->data("field_name", "value", true);

e.g.

$this->data("phone", $phone, true);

Please see this FAQ for some more info.
​
Bob

Hi Bob
​
Thanks.
The difficulty I have is, I have two returns:
​

return $this->data("phone", $phone, true);
return $this->data("city", $city, true);

​
And in the views tab I have two textfields: one for phone and one for city.
​
{var:php3} loads the first return which is "phone". I can't get "city"
​
Following all are not working:
{var:php3.city}
{var:php3[city]}
{var:php3(city)}
​

​
​
​
Adding
​
​

$this->data("phone", $phone, true);

​
into the "Value" field is not working either, it outputs the whole string.
​
I did check the FAQ but I did not find the correct code.
​
What do I have to add into the Value field?
​
Thanks.
Patrick

Hi Patrick,
​
I don't think you need the 'return's in your code - you are setting values in the form data here - not returning them.
​
Bob