How can I make grid cells/fields clickable and editable?
Thank you.
Individual cells in grid editable?
Individual cells in grid editable?
Regards and thanks,
Harry Carter
Harry Carter
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: Individual cells in grid editable?
In grid display options property there is a check box allow inline edit.
Re: Individual cells in grid editable?
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.
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
Harry Carter
Re: Individual cells in grid editable?
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
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
-
- Posts: 1457
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: Individual cells in grid editable?
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.
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.
Re: Individual cells in grid editable?
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!
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
Harry Carter
-
- Posts: 1457
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: Individual cells in grid editable?
That is all doable but you just need to alter the way you think about it.
Two BOs
StockList with
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
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
Two BOs
StockList with
- ItemNumber
- ItemDesc
- UnitPrice
- psStockItem (peer relationship to StockList)
- scStockItemDescription
- scStockItemNumber
- OrderPrice (Int)
Code: Select all
IF OrderLine.psStockItem WAS CHANGED AND OrderLine.psStockItem IS DEFINED THEN OrderLine.OrderPrice=OrderLine.psStockItem.UnitPrice
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
Your OrderLine.OrderPrice has to be separate from the StockItem.UnitPrice
Re: Individual cells in grid editable?
Pointswell,
I actually think that I completely understand
Thank you.
I actually think that I completely understand
Thank you.
Regards and thanks,
Harry Carter
Harry Carter
-
- Posts: 1457
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: Individual cells in grid editable?
My pleasure. Let me know how you get on.numberz wrote:Pointswell,
I actually think that I completely understand
Thank you.
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
Re: Individual cells in grid editable?
Pointswell,
You state "peer relationship to StockList"
No matching data? Just one way?
Thank you.
You state "peer relationship to StockList"
No matching data? Just one way?
Thank you.
Regards and thanks,
Harry Carter
Harry Carter
-
- Posts: 1457
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: Individual cells in grid editable?
No matching data unless you want to be able to look at the StockList and see every OrderLine that that StockItem appears on.numberz wrote:Pointswell,
You state "peer relationship to StockList"
No matching data? Just one way?
Thank you.
Re: Individual cells in grid editable?
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
Bruce
-
- Posts: 1457
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: Individual cells in grid editable?
stop it BruceBLOMASKY 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
No go on.
No stop it really
Re: Individual cells in grid editable?
Pointswell,
I'm lost on "OrderLineUpdateMasterPrice"
Where are you getting this from?
Thank you.
I'm lost on "OrderLineUpdateMasterPrice"
Where are you getting this from?
Thank you.
Regards and thanks,
Harry Carter
Harry Carter
-
- Posts: 1457
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: Individual cells in grid editable?
numberz wrote:Pointswell,
I'm lost on "OrderLineUpdateMasterPrice"
Where are you getting this from?
Thank you.
Create a Process call it "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.
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.