Pointswell,
LOL...and THIS is why I wish for a Newbie area.
Imagine that if I knew how to create rules and processes that I'd probably be knowing how to edit a cell.
You and others on here are breathing different air than me I'm afraid. I'm lost.
I'll study what you typed but I'm lost.
"Sure it can be done! Put your left foot in, scratch your ass, chew gum, sing Bubbaloo, cross your eyes...and on and on"
It's not your fault of course, it's the great lack of knowledge on my part.
I am greatly appreciative.
Thank you.
Individual cells in grid editable?
Re: Individual cells in grid editable?
Regards and thanks,
Harry Carter
Harry Carter
Re: Individual cells in grid editable?
I'm I'm reading correctly, you advised me to create a rule...then create a Process that contains an update rule?
Thank you.
Thank you.
Regards and thanks,
Harry Carter
Harry Carter
Re: Individual cells in grid editable?
PointsWell wrote: 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.
Code: Select all
DISPLAY QUESTION 'Do you want to actually do what this action is requesting?'
IF Question.Reply='Yes' THEN
Do_something_that_involves_Yes
ELSE
IF Question.Reply='No' THEN
Do_something_that_involves_No
ELSE
DISPLAY MESSAGE 'ERROR!'
Avid Linux user....
-
- Posts: 1473
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: Individual cells in grid editable?
I made a mistake, you can't ask a question the way I suggested.
I made a little example that will do it.
The StockList will pre-populate
Create an OrderLine
When you tab out of the field it will save the form and set the OrderPrice
Change the OrderPrice then check the Update Master check box then save
When you refresh the StockList on the left it will have updated the price.
It's not as elegant as being able to ask the user.
There is a READ PROTECT rule that you can ignore - that was a to see if you could lock the Update Master field - but that won't work on a grid when you apply it only to an attribute (only whole objects)
N.B. File is not a zip - remove .zip from filename to use the BSV.
I made a little example that will do it.
The StockList will pre-populate
Create an OrderLine
When you tab out of the field it will save the form and set the OrderPrice
Change the OrderPrice then check the Update Master check box then save
When you refresh the StockList on the left it will have updated the price.
It's not as elegant as being able to ask the user.
There is a READ PROTECT rule that you can ignore - that was a to see if you could lock the Update Master field - but that won't work on a grid when you apply it only to an attribute (only whole objects)
N.B. File is not a zip - remove .zip from filename to use the BSV.
- Attachments
-
- UpdateMasterList.bsv.zip
- Not a zip file. Remove.zip from filename
- (44.83 KiB) Downloaded 572 times
Last edited by PointsWell on Thu Jan 09, 2020 10:11 pm, edited 1 time in total.
Re: Individual cells in grid editable?
Hmm...says that there aren't any files in that zipped folder.
Regards and thanks,
Harry Carter
Harry Carter
-
- Posts: 1473
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: Individual cells in grid editable?
The forum won't allow you to attach bsv files. Just take the zip suffix off and leave it as a bsv.numberz wrote:Hmm...says that there aren't any files in that zipped folder.
General rule of thumb if someone posts a file with a double suffix (e.g. application.bsv.zip) and the last suffix is .zip then it probably isn't a real zip file.
Re: Individual cells in grid editable?
Pointswell,
Again, thanks.
SOLVED
Again, thanks.
SOLVED
Regards and thanks,
Harry Carter
Harry Carter