Buy Now
Sign in

Data DB in Dropdown

SPABO , April 22 2017, 18:15
S
SPABO 637
April 22 2017, 18:15 #367315
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 27
April 22 2017, 20:01 #367319
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 637
April 23 2017, 12:04 #367330
Max
That's what I mean, the link isn't helpfull
Rgds
Kees
admin 27
April 23 2017, 18:48 #367342
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 637
April 24 2017, 07:35 #367360
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 27
April 24 2017, 08:20 #367361
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 637
April 24 2017, 15:50 #367384
#2...Select type Is not in Read Data
#3....just the field name only???
admin 27
April 24 2017, 16:53 #367390
 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
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!