Method Community

Where and how can I have the grid calculate the value of a column? I have a grid, one column has the current hours, next column has the next service hours, I want the third column to display yes or no depending on "current hours" be greater or equal to "next service hours"

I got them to display the way I wanted, but when I try to select one of the choices of the dropdown it won't let me, nothing happens This is what I did Screen is based on fixed asset item table, the dropdowns are based on inventory item table 1. Edit fixed asset item table and added a dropdown field based on item inventory table to ...

Ok, I created the fields in the fixed asset item table, and inserted them into the screen, and it seems to be working fine, the only problem I have now is that the first column is the recordId and that it not what I want, and I dont see how to changed that

I spoke to soon, the dropdown fields are working, but when I save the screen for one record Id and i select a different recordId the value is saved there too.

I created a dropdown field in the fixed asset item table called "air filter" based on the item inventory table. I want to be able to select a particular air filter part number for a particular piece of equipment. But when I place the field in the screen (fixed asset item table) when the screen first loads i see the inventory in the ...

That will never happen. it is a grid of work orders completed for the equipment, every work order will have more hours that the one before, the value i need will always be the last work order completed

when looping through a grid how do I get the bigger record, I have a grid where we keep the hours for the equipment, I only whant to get the record with the most hours, how can I achieve that?

Thank you

Where is the last completed activity value stored?

What table should I use for the screen