Forums

Use of returned value for Selected Values in a dropdown

ediaccount 05 Mar, 2017
Hello:

Trying to use the returned value from a php function for the Selected Value in a drop down. But it doesn't appear to work. Can returned values be used in the Selected Value field?

In the Selected Values field of the drop down I am putting {var:get_parent_id}. I am running {fn:get_parent_id} in the Event just before the view:form. To make sure the function is properly returning a value, I used the same {var:get_parent_id} in a text field of the same form, and it is showing the correct value.

Thanks -

-Brian
Max_admin 06 Mar, 2017
Hi Brian,

Yes, this feature was does not exist in the latest release, but i have just fixed it, if you need the patch file before the official update then please send me a message using the "Contact us" page.

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
webuniverse 13 Jul, 2017
Hi Max

is this in "ChronoConnectivity_V6.0.3_Component.zip" now exist?

I try some versions, but it dosnt work 🧐

Best regards,
Corinne
Max_admin 14 Jul, 2017
Hi Corinne,

Yes, that should be working already, the var is working in a field "label" but not in the "selected value" ?

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
webuniverse 14 Jul, 2017
Hi Max

Now, the dropdown selection works, but i dont know how i can give the first value for the load. Actually it shows nothing.
Debugger:
"WHERE `Aufnahmen`.`status` = ''"


Where can i set the first value "status = offen" is my big question lightbulb

Thank you
Corinne
webuniverse 14 Jul, 2017
1 Likes
Wohoooo i found the solution in two small character /- 😀

This work
status:{data:ddstatus}/-


Nice, nice, nice 😃
Max_admin 19 Jul, 2017
Hi Corinne,

The syntax "status:{data:ddstatus}" is enough, but the "/-" means that if the shortcode returns nothing then ignore that parameter in the query, I guess it worked for you because you do not usually have the status field available.

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
CSDweb 23 Dec, 2017
This is good, but how do you get it to return just non-null records? When I use a where condition, with or without the /- I get back whatever number of is set in the limited dialog (this is using CC v6.06) or just all of the null records
Max_admin 27 Dec, 2017
Hi CSDweb,

You can use the
Field/IS NOT:{value:null}
syntax

Best regards
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.