Data from Entries sort field and sort order

Two things I think are needed to make this the best form plugin on the net

 

For dynamic data,where you Import Data from:

 

It would be fantastic to have a WHERE field associated to it…..ie import data from ‘Price List’ WHERE ‘Category’ == ‘Waitress’

Then show more than one field, ie at the moment you can only show Title…..ideally showing Title and Price would be fantastic  in the display as

Thanks for all of your help to date.

25 votes +1

Definitely! I already had Where options on the list, but not displaying multiple fields in the choices. Good idea.

 

Here are some of the planned enhancements for Data from Entry field options:

* add option to order data from entries fields
* add where options to data from entries fields (ie only show US states)

* add option to use a GET/POST param (also in drop-down, checkbox, and radio fields)

 

Add sorting options to the Data from Entries field type.

Data from Entries, at render time, sorts alphanumeric ascending on the selected display field.

I propose the addition of a related "Sort Order" field and ascending/descending sort order options to the Data from Entries field options.

For example:

I have an admin-only Formidable Form called "Source Codes"

This has two fields, Source Code > simple text, Sort Order > simple text

Sample data:
"Web Search", "0010"
"Door Hanger", "0050"
"Clipper Magazine", "0100"
"Other", "9999"

I have another Formidable Form called "Estimate Request"
This has, among others, a "How did you hear about us?" > Data from Entries field referencing the entries in the "Source Codes" Form. I represent this as a dropdown select.

On the field options, I would like the ability to specify a Sort Order field as the render order key.

I would then be able to specify whether this key should be sorted Ascending or Descending.

In my example above, terms would render in order according to the Sort Order field:
Web Search
Door Hanger
Clipper Magazine

The default render order would have been (alphanumerically):
Clipper Magazine
Door Hanger
Other
Web Search

Here's my vote for one of your next planned enhancement mentioned above :

 add option to order data from entries fields

Really looking forward to see that !

Cheers!

JS

did this ever get implemented, i updated the code today on one of my master websites, but it looks like this was never implemented.

This is still listed as an open suggestion which means it has not been added yet. This is not yet on our timeline.

Reply to this Topic

*