Method Community

How do you create a dropdown field in a grid?

In the new work order screen, in the job item grid I want to create a new dropdown field that will let me choose from fixed asset items

Marcelo,

Thank you.

I am working on a new screen to assign work orders to equipment. So we can keep track of all our maintenance on our trucks, mowers, blowers etc.

I have all my equipment in QB as fixed assets.

So I am thinking in the grid of the new work order screen I have the job item column that I can filter so only service job items will show, next to it I can create a new column that will show the fixed asset items only, so that way I can link work orders to the equipment.

Does this make sense?

Will it work?

Glad to help!