Data DB in Dropdown

SPABO 22 Apr, 2017
I want to make a new form, whereby subscribers can select a date
This field is in the DB (Datum)

I quess in the OnLoad a DataRead Event?
In the Where part: Model.Datum:{data:Datum} ??

But what/where in the dropdown?
Max_admin 22 Apr, 2017
Hi Kees,

You mean a date from a list of dates in a dropdown ?

If yes then please check this post:
http://www.chronoengine.com/forums/posts/t102984.html#367288

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
SPABO 23 Apr, 2017
Max
That's what I mean, the link isn't helpfull
Rgds
Kees
Max_admin 23 Apr, 2017
Hi Kees,

At which part of the info you had a problem ?

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
SPABO 24 Apr, 2017
Max
The link is very confusing, and does not describe the steps to follow
A handy example would be usefull

Again, pls find teh question I asked: Is this the correct way to go forward?

Kees
Max_admin 24 Apr, 2017
Hi Kees,

The steps are as the following:

#1- drag a read data action ABOVE the display section action in the load event.
#2- in the read data, set the table to your table of choice, set the model name, and set the "select type" to "key/value" pairs.
#3- set the fields to retrieve to the field name you want to have in the dropdown.
#4- in your dropdown "options" field, add this: {var:read_data_name}

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
SPABO 24 Apr, 2017
#2...Select type Is not in Read Data
#3....just the field name only???
Max_admin 24 Apr, 2017
Answer
Hi Kees,

#2- Read data > Data settings > Select type
#3- Yes, that should work, or Model_Name.field_name, the field_name here is the table field name.

Best regards,
Max
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.