Buy Now
Sign in

Data DB in Dropdown

SPABO , April 22 2017
Answered
S
SPABO
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?
admin
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
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
S
SPABO
Max
That's what I mean, the link isn't helpfull
Rgds
Kees
admin
Hi Kees,

At which part of the info you had a problem ?

Best regards,
Max
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
S
SPABO
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
admin
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
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
S
SPABO
#2...Select type Is not in Read Data
#3....just the field name only???
admin
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
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!