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

Re: Individual cells in grid editable?

Post by numberz »

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.
Regards and thanks,
Harry Carter
numberz
Posts: 166
Joined: Sat Aug 05, 2017 12:13 am
Location: New Hampshire - USA

Re: Individual cells in grid editable?

Post by numberz »

I'm I'm reading correctly, you advised me to create a rule...then create a Process that contains an update rule?

Thank you.
Regards and thanks,
Harry Carter
intra
Posts: 279
Joined: Thu Oct 11, 2012 1:30 pm
Location: Australia

Re: Individual cells in grid editable?

Post by intra »

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....
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Individual cells in grid editable?

Post by PointsWell »

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.
Attachments
UpdateMasterList.bsv.zip
Not a zip file. Remove.zip from filename
(44.83 KiB) Downloaded 465 times
Last edited by PointsWell on Thu Jan 09, 2020 10:11 pm, edited 1 time in total.
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...says that there aren't any files in that zipped folder.
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:Hmm...says that there aren't any files in that zipped folder.
The forum won't allow you to attach bsv files. Just take the zip suffix off and leave it as a bsv.

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.
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,
Again, thanks.

SOLVED
Regards and thanks,
Harry Carter
Post Reply