It's the first time I'm using them so I may be confused, but the behavior doesn't seem right. I've been documenting it for the past three hours... hopefully something comes out of this!
First, Forms 10 Update 1 has been installed:
I have the following table in my form:
The Proficiency dropdown field has the following options:
- Basic
- Conversational
- Fluent
Below is my SQL table. It only has one row, with English set to Fluent:
And here is my lookup rule. It's very simple:
Then, to test it, I navigate to this URL: http://localhost/Forms/form/new/30?uuid=1
Here's what I get:
Which looks fine, BUT...
Where are the other two options in the dropdown? This is a form we send back to the initiator to let them make changes. What if they decide to get tested at the Conversational level instead of Fluent and want to change their language proficiency? (This was a problem in 9.1 and 9.2 as well, but it's such a game-breaking bug that we were assuming it would get fixed, or at least an alternative behavior provided as an option, as Eric indicated here.)
There's more... when I click "Add language", it keeps adding a row with the exact same data, when it should be adding blank rows:
The table option clearly says "append rows to the rows populated by a data source or variable", so shouldn't it look like this instead when you click "Add language"?
Just for fun I wanted to see how it would behave when there's more than one row in the database table:
After the form loads with that URL, setting the uuid field value to "1", the table is now blank...
Oddly enough, the "Conversational" option is gone from the dropdown:
And English and French have been added to the Language single-line field as auto-suggestion values:
?????
Am I missing something here? Because, based on how I have configured my lookup rule, and how this feature has been requested in the past, I expect this database table:
With these options:
To be reflected like this on the form when the lookup rule runs: