Question

Alphabetical Forms lookup/Forms Email addresses

Forms

Updated February 6, 2015

asked on November 11, 2013

In Laserfiche Forms, when you create a rule for a drop down populated from a table, the entries are not being populated in 0-9, A-Z order for first letter of name in this case. How do you resolve that.

Also, How does task notification identify email address for assigned AD user or Laserfiche user in Forms Business Process to send a notification email?

0 0

Answer

APPROVED ANSWER

replied on November 11, 2013

The order of the results from a database lookup will not be modified by Forms, meaning that if you’d like the lookup to populate items alphabetically, they should be sorted alphabetically in the table that Forms is looking at.

As for the email notification, you’ll see an attribute in the Laserfiche account that Forms is sending the notification to called Forms[Email] that stores the email address for each user.

0 0

replied on February 5, 2015

To expand on this a bit: I have a case where a lookup in Forms is being populated by a sorted view. The original listing wasn't sorted, but was updated after implementation to sort alphabetically. This list isn't showing as alphabetized in the original form, but if it is tied to a new form, it lists in order.

What also may be of note, is that the original form is using this exact same list in 7 different fields on the form. The new form (with correct alphabetization) only uses the lookup in one place.

Thoughts?

0 0

replied on February 5, 2015 • Show version history

I'd recommend attempting to copy the business process to see if that sorts the items from the database lookup. You can copy the business process form the manage page. If the sorting only works on new processes, this will trick Forms in a way that makes it believe this process is brand new, when in reality, it's the exact same process with a different identifier.

Let me know how it works out and if you need additional assistance!

0 0

replied on February 6, 2015

Unfortunately, we already tried that and it didn't work.

0 0

Replies

replied on November 11, 2013 • Show version history

Regarding sorting of list from a database look up, I understand that it is not being modified by Forms. However, can this feature be added on to the next version. It makes the product more user friendly and also saves you time from sorting everytime you need to add a value. If Dynamic Fields in Admin Console can do it, I am assuming that it can be done. Let me know if this is possible.

1 0

replied on November 12, 2013

Laserfiche Forms 9.1 will add support for SQL stored procedure lookup rules. Using stored procedure lookup rules, you'll be able to sort the results before returning them to Laserfiche Forms.

0 0

replied on November 18, 2013

So to add to this question...I just created a SQL DB using County names (A-Z). They are alphabetical in SQL, however, when I click on the drop down in Forms, they are not...what am I missing and not sure why this is occuring?

0 1

You are not allowed to follow up in this post.

Question

Question

Alphabetical Forms lookup/Forms Email addresses

Answer

Replies

Sign in to reply to this post.