dynamic data db problem

How to fix a dynamic dropdown not saving data and sort its options.

Overview

The dropdown data fails to save because the corresponding database column is missing, and the options are not sorted.
First, add the missing column to your database table. Then, use the Order setting in the DB Read action or a Custom Code action to sort the dropdown options alphabetically.

ca catsitters 14 Nov, 2014

Hello!
I have a problem with the speiochern of data when I use a dynamic drop down box.

see:
dynamic data db problem image 1

What am I doing wrong?

many greetings

Gr GreyHead 14 Nov, 2014

Hi catsitters,

What exactly is the problem?

The value of plz_query_dynamic is not saving because there is no plz_query_dynamic column in the database table.

Bob

ca catsitters 19 Nov, 2014

Found error.😀
dynamic data db problem image 2

greeting
Stephan

ca catsitters 19 Nov, 2014

hello😟

I have a new problem.
The data in the drop down box should be sorted alphabetically. e.g. A-Z or 0-9.
Where can I change the setting?

greeting
Stephan

Gr GreyHead 20 Nov, 2014

Answer

Hi Stephan,

The Order box in the DB Read action should let you set the order? If you want something more customised you can edit the data with a Custom Code action after the DB Read.

Bob

This topic is locked and no more replies can be posted.