Dynamic Conditional Values Record Picking
Hello,
I have an app that is building a scope of work based on several variables. I currently have four tables.
Inventory Items
Scope of Work
Rooms
Materials
Inventory Items ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHi Aaron,
I don't believe that in your use case you won't be able to get a typical conditional drop down working. I do have another method which would work like this.
The user would launch off of a room and under the covers that would set a user focus so that the app knows what room the user is focussed on. That click would land the user on a report of all Inventory items which qualify as being valid for that Focus Room. The user would be able to click click click to quickly add materials to the room and then when they are done they would click another button to get back to the room where they would see that all the material child records have been added. You can decide if once an inventory item is selected for a room that it then becomes ineligible to be selected the second time.
I would probably take a couple of hours of consulting time to get working. If you have a small budget feel free to contact me directly by email.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
I don't believe that in your use case you won't be able to get a typical conditional drop down working. I do have another method which would work like this.
The user would launch off of a room and under the covers that would set a user focus so that the app knows what room the user is focussed on. That click would land the user on a report of all Inventory items which qualify as being valid for that Focus Room. The user would be able to click click click to quickly add materials to the room and then when they are done they would click another button to get back to the room where they would see that all the material child records have been added. You can decide if once an inventory item is selected for a room that it then becomes ineligible to be selected the second time.
I would probably take a couple of hours of consulting time to get working. If you have a small budget feel free to contact me directly by email.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------