Load data from DB with user_id

Question

Hello!
Many thanks for CF6

The situation:
Use CF6. All data is output from the DB in Dropdown

The problem:
What do I need to specify so that the data in Dropdown is only for the user?
And what settings you need to specify the data to be in order (1-9, A-Z)?

Thanks for the help
Max

Max_admin · Accepted Answer

Hi Max,

This has to be configured in the "Read data" action, in the "Where conditions" use:

field_name:{user:id}

in order to get records matching a specific user id, and in the order by use some field name: field_name/asc or field_name/desc

Best regards,
Max

Load data from DB with user_id

Filter and sort database data in a ChronoForms dropdown.

Overview