MagicCell Help

[stanley]

I need to be able to do an OR statement in a magiccell. I need to find out a few things first.

One if the Price of an item is 0 then leave this cell blank.
Two if the Price is GT 0 and the Qty is 0 then go to backorder.
Three if the Qty is GT 0 and the Price is GT 0 then let the user buy.
Four if the Qty is GT 0 and the Price is 0 then leave cell blank.

Is there a way to do this type of thing in a magic cell? If so how?

[Mark]

Hi Stanley,
Yes, you can do that using Extended MagicCell.
See Programming Example 2 at:
http://www.mmsTools.com/EP
I hope that helps.
Mark


------------
stanley at 5/29/01 1:21:00 PM

I need to be able to do an OR statement in a magiccell. I need to find out a few things first.

One if the Price of an item is 0 then leave this cell blank.
Two if the Price is GT 0 and the Qty is 0 then go to backorder.
Three if the Qty is GT 0 and the Price is GT 0 then let the user buy.
Four if the Qty is GT 0 and the Price is 0 then leave cell blank.

Is there a way to do this type of thing in a magic cell? If so how?

[stanley]

Ok not sure how the OR part comes in. As far as saying :

Price GT 0 AND Qty GT 0 then Buy

That part was the easy part. But I also need to check to see the following:

Price EQ 0 then ClearCell
OR
Price GT 0 AND Qty = 0 then Backorder

So it would have to follow the following guidelines:

if Price GT 0 AND Qty GT 0 then Buy
elseif Price EQ 0 then ClearCell
elseif Price GT 0 AND Qty = 0 then Backorder

Am I missing something simple here?

Thanks
Stanley
------------
Mark at 5/29/01 1:38:25 PM

Hi Stanley,
Yes, you can do that using Extended MagicCell.
See Programming Example 2 at:
http://www.mmsTools.com/EP
I hope that helps.
Mark


------------
stanley at 5/29/01 1:21:00 PM

I need to be able to do an OR statement in a magiccell. I need to find out a few things first.

One if the Price of an item is 0 then leave this cell blank.
Two if the Price is GT 0 and the Qty is 0 then go to backorder.
Three if the Qty is GT 0 and the Price is GT 0 then let the user buy.
Four if the Qty is GT 0 and the Price is 0 then leave cell blank.

Is there a way to do this type of thing in a magic cell? If so how?

[Mark]

Stanley,
You are starting to get into your "Application programming" which goes beyond the scope of this forum. Please contact us directly for more detailed assistance. Email: support@majormicro.com
Thanks,
Mark.


------------
stanley at 5/29/01 1:53:46 PM

Ok not sure how the OR part comes in. As far as saying :

Price GT 0 AND Qty GT 0 then Buy

That part was the easy part. But I also need to check to see the following:

Price EQ 0 then ClearCell
OR
Price GT 0 AND Qty = 0 then Backorder

So it would have to follow the following guidelines:

if Price GT 0 AND Qty GT 0 then Buy
elseif Price EQ 0 then ClearCell
elseif Price GT 0 AND Qty = 0 then Backorder

Am I missing something simple here?

Thanks
Stanley
------------
Mark at 5/29/01 1:38:25 PM

Hi Stanley,
Yes, you can do that using Extended MagicCell.
See Programming Example 2 at:
http://www.mmsTools.com/EP
I hope that helps.
Mark


------------
stanley at 5/29/01 1:21:00 PM

I need to be able to do an OR statement in a magiccell. I need to find out a few things first.

One if the Price of an item is 0 then leave this cell blank.
Two if the Price is GT 0 and the Qty is 0 then go to backorder.
Three if the Qty is GT 0 and the Price is GT 0 then let the user buy.
Four if the Qty is GT 0 and the Price is 0 then leave cell blank.

Is there a way to do this type of thing in a magic cell? If so how?

[Frank Kwong]

Magic cell is for display control using an IF..ELSEIF approach. The application you mentioned can be easily done by just exporting the PRICE and QTY field and then go from there to check for their values and then branch to another ASP file.

FK

------------
Mark at 5/29/01 1:59:23 PM

Stanley,
You are starting to get into your "Application programming" which goes beyond the scope of this forum. Please contact us directly for more detailed assistance. Email: support@majormicro.com
Thanks,
Mark.


------------
stanley at 5/29/01 1:53:46 PM

Ok not sure how the OR part comes in. As far as saying :

Price GT 0 AND Qty GT 0 then Buy

That part was the easy part. But I also need to check to see the following:

Price EQ 0 then ClearCell
OR
Price GT 0 AND Qty = 0 then Backorder

So it would have to follow the following guidelines:

if Price GT 0 AND Qty GT 0 then Buy
elseif Price EQ 0 then ClearCell
elseif Price GT 0 AND Qty = 0 then Backorder

Am I missing something simple here?

Thanks
Stanley
------------
Mark at 5/29/01 1:38:25 PM

Hi Stanley,
Yes, you can do that using Extended MagicCell.
See Programming Example 2 at:
http://www.mmsTools.com/EP
I hope that helps.
Mark


------------
stanley at 5/29/01 1:21:00 PM

I need to be able to do an OR statement in a magiccell. I need to find out a few things first.

One if the Price of an item is 0 then leave this cell blank.
Two if the Price is GT 0 and the Qty is 0 then go to backorder.
Three if the Qty is GT 0 and the Price is GT 0 then let the user buy.
Four if the Qty is GT 0 and the Price is 0 then leave cell blank.

Is there a way to do this type of thing in a magic cell? If so how?