Individual cells in grid editable?

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
numberz
Posts: 166
Joined: Sat Aug 05, 2017 12:13 am
Location: New Hampshire - USA

Individual cells in grid editable?

Post by numberz »

How can I make grid cells/fields clickable and editable?
Thank you.
Regards and thanks,
Harry Carter
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Re: Individual cells in grid editable?

Post by swiftinitpvtltd »

In grid display options property there is a check box allow inline edit.
numberz
Posts: 166
Joined: Sat Aug 05, 2017 12:13 am
Location: New Hampshire - USA

Re: Individual cells in grid editable?

Post by numberz »

But not when the information is in a grid that is a shortcut.
Trying to wrap my head around how I can create an item list (a list with numerous attributes), then call one of those items into a project (grid) and be able to edit certain cells.
Thank You.
Regards and thanks,
Harry Carter
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Individual cells in grid editable?

Post by BLOMASKY »

Sorry, I don't have a good answer, but I don't know of any tools that allow you to edit more than one table at the same time. That would be what you are trying to do with a shortcut.

You could have an editable field in the child table (the one you are editing, and prior to displaying your query, have it populated with the field from the parent table (the shortcut field) than have a rule for whenever this new field is edited, have it update the parent table.

Bruce
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Individual cells in grid editable?

Post by PointsWell »

If you have a shortcut on a grid and make it inline editable then it is smart enough to give you a drop down.

You need to define each column that is inline editable and then make the grid inline editable. Don't have access to a screen at the moment to check where these are, but will post later.

You can only edit to immediate peers Bo.psExample can be edited via BO.scExample so you couldn't make a shortcut to BO.psExample.psNextLevel and edit that.
numberz
Posts: 166
Joined: Sat Aug 05, 2017 12:13 am
Location: New Hampshire - USA

Re: Individual cells in grid editable?

Post by numberz »

Hmm, maybe I'm not explaining correctly.

101 Redwood Flooring .50 SF
102 Copinal Flooring .45 SF
102 Diagonal Flooring .35 SF

So, the BO is "Flooring" and the attributes are "ItemNumber", "ItemDDescription", "UnitPrice".

I need to be able to enter a bunch of these to create a Master item List that I can store away, refer to and fetch. I know that I can go to each item and edit individually in form view but what I need is to call the item in to a grid from the Master list by typing the item number, into a job and be able to edit the Unit Price, just for that job but not affect the Master list item at all.

We have this capability already with other programs. We can type in an item code, have the code display all of the attributes (or cells) of an item and we can click on say, the unit price cell and change it to whatever we want. We actually have a prompt appear that asks if we want to update the Master material price...with a choice of yes and no. If we answer yes, the master material price changes for all future fetches. If we answer no, then the item unit price is changed for just this job.

This is old stuff, we were doing this 40 years ago, there has got to be a way, right?

Thanks for all replies!
Regards and thanks,
Harry Carter
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Individual cells in grid editable?

Post by PointsWell »

That is all doable but you just need to alter the way you think about it.

Two BOs
StockList with
  • ItemNumber
  • ItemDesc
  • UnitPrice
OrderLine
  • psStockItem (peer relationship to StockList)
  • scStockItemDescription
  • scStockItemNumber
  • OrderPrice (Int)
Set Business Rule on OrderLine

Code: Select all

IF OrderLine.psStockItem WAS CHANGED AND OrderLine.psStockItem IS DEFINED THEN OrderLine.OrderPrice=OrderLine.psStockItem.UnitPrice
Make this a dynamic rule so that it runs immediately and not just when saving

Make your OrderLine grid inline editable, make columns OrderLine.scStockItemNumber editable (this will make it a drop down list in the grid) make OrderPrice editable

Add a Business Rule to OrderLine

Code: Select all

IF OrderLine.OrderPrice IS DEFINED AND OrderLine.OrderPrice WAS CHANGED THEN OrderLineUpdateMasterPrice
Where OrderLineUpdateMasterPrice is a process that receives OrderLine as an input and asks a question do you want to update. If Yes then you update OrderLine.psStockItem.UnitPrice to equal OrderLine.OrderPrice.

Your OrderLine.OrderPrice has to be separate from the StockItem.UnitPrice
numberz
Posts: 166
Joined: Sat Aug 05, 2017 12:13 am
Location: New Hampshire - USA

Re: Individual cells in grid editable?

Post by numberz »

Pointswell,
I actually think that I completely understand :)
Thank you.
Regards and thanks,
Harry Carter
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Individual cells in grid editable?

Post by PointsWell »

numberz wrote:Pointswell,
I actually think that I completely understand :)
Thank you.
My pleasure. Let me know how you get on.

On reviewing the OrderLine.OrderPrice business rule you'll need to change that to be

Code: Select all

IF OrderLine.OrderPrice WAS CHANGED AND OrderLine.OrderPrice<>OrderLine.psStockItem.UnitPrice 
Otherwise the rule will keep tripping the way it was originally written
numberz
Posts: 166
Joined: Sat Aug 05, 2017 12:13 am
Location: New Hampshire - USA

Re: Individual cells in grid editable?

Post by numberz »

Pointswell,
You state "peer relationship to StockList"
No matching data? Just one way?

Thank you.
Regards and thanks,
Harry Carter
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Individual cells in grid editable?

Post by PointsWell »

numberz wrote:Pointswell,
You state "peer relationship to StockList"
No matching data? Just one way?

Thank you.
No matching data unless you want to be able to look at the StockList and see every OrderLine that that StockItem appears on.
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Individual cells in grid editable?

Post by BLOMASKY »

Sorry, I didn't understand what you were asking. Lucky, PointsWell is much smarter than me and better looking and figured out what you want to do.

Bruce
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Individual cells in grid editable?

Post by PointsWell »

BLOMASKY wrote:Sorry, I didn't understand what you were asking. Lucky, PointsWell is much smarter than me and better looking and figured out what you want to do.

Bruce
stop it Bruce
No go on.
No stop it really :D
numberz
Posts: 166
Joined: Sat Aug 05, 2017 12:13 am
Location: New Hampshire - USA

Re: Individual cells in grid editable?

Post by numberz »

Pointswell,
I'm lost on "OrderLineUpdateMasterPrice"

Where are you getting this from?

Thank you.
Regards and thanks,
Harry Carter
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Individual cells in grid editable?

Post by PointsWell »

numberz wrote:Pointswell,
I'm lost on "OrderLineUpdateMasterPrice"

Where are you getting this from?

Thank you.
Where OrderLineUpdateMasterPrice is a process that receives OrderLine as an input and asks a question do you want to update. If Yes then you update OrderLine.psStockItem.UnitPrice to equal OrderLine.OrderPrice.
Create a Process call it "OrderLineUpdateMasterPrice"
In the process:
Ask user "Do you want to update master price"
If they select Yes then update the StockItem.UnitPrice

Not at computer at the moment so can't remember the exact syntax for DISPLAY QUESTION and the reply but it should be in the manual.
Post Reply