Some lookups have a endless growing no. of entries (e.g. "orders"), so that it becomes more and more difficult to find and select an entry.
A partly solution: Lookup fields can be filtered and reordered by "Advanced..." - SQL-Code, e.g. "orders" filtered by a status <> "delivered".
The problem: in detail view of "old" entries the status of all delivered orders isn't be shown, because the status allows the order not beeing selected in the dropdown-list.
In table view it's okay, means: the entry in order table is correct. It's just a problem of displaying it.
How to solve that?
Is there a way to change a lookup field / dropdown list to beeing displayed as a text field when filter conditions have changed (e.g. when order status = "delivered")?
Or maybe a way to display an "old" not selectable "free" entry within a lookup?
Thanks in advance!
Koepi
Lookup Fields: huge no. of entries, filter and detail view
-
- AppGini Super Hero
- Posts: 85
- Joined: 2014-06-14 03:08
- Location: India
- Contact:
Re: Lookup Fields: huge no. of entries, filter and detail vi
Hello,
Can you please provide some screenshots of the issue. I am trying to help but i couldn't able to pinpoint your issue.
Can you please provide some screenshots of the issue. I am trying to help but i couldn't able to pinpoint your issue.
Re: Lookup Fields: huge no. of entries, filter and detail vi
Hi Uday,
thanks for thinking about the issue.
Here some more details.
Let's say we've a growing number of orders .
These orders can be checked as "archieved" when they became "old", because of not want to have an endless list of order entries you've actual to deal with.
Now you can create tasks (Aufgaben) depending on an order.
In that table there's a lookup to choose the corresponding order.
These lookup is filtered by archieve fields which are not checked:
Now we check the field "archiviert" in the first screenshot above.
In the table view of the tasks the "old" order is displayed fine.
BUT not in the dv!
Because the order isn't in the lookup list anymore it isn't displayed.
Instead lookup is emty.
How to solve that?
Lookups should accept every value, not only that in the lookup list?
Thanks in advance!
Koepi
thanks for thinking about the issue.
Here some more details.
Let's say we've a growing number of orders .
These orders can be checked as "archieved" when they became "old", because of not want to have an endless list of order entries you've actual to deal with.
Now you can create tasks (Aufgaben) depending on an order.
In that table there's a lookup to choose the corresponding order.
These lookup is filtered by archieve fields which are not checked:
Now we check the field "archiviert" in the first screenshot above.
In the table view of the tasks the "old" order is displayed fine.
BUT not in the dv!
Because the order isn't in the lookup list anymore it isn't displayed.
Instead lookup is emty.
How to solve that?
Lookups should accept every value, not only that in the lookup list?
Thanks in advance!
Koepi
Re: Lookup Fields: huge no. of entries, filter and detail vi
Very similar or same problem here....used advanced lookup and updated column with data, the data shows in the record list at the top with the updated lookup info, but when I click on the record and look at the detail view below the lookup column is now empty (lost previous updated info). IF someone were to update another column in this record, the previous lookup data would be lost unless they noticed it wasn't being carried forward. For the previous lookup to remain, they would have to re-update the column using the pull-down again.
Advanced lookup fields updated by using pull-down once updated and saved should not have to be re-done upon selecting the record again. the detail view should still show the updated data just like it shows at the top in the record list.
Advanced lookup fields updated by using pull-down once updated and saved should not have to be re-done upon selecting the record again. the detail view should still show the updated data just like it shows at the top in the record list.
Re: Lookup Fields: huge no. of entries, filter and detail view
Hello friends, how are you?
This question raised is what has been bothering me. I create many views by sql and that are not shown in the lookup fields. Does anybody know how to solve this?
This question raised is what has been bothering me. I create many views by sql and that are not shown in the lookup fields. Does anybody know how to solve this?