Increase/decrease step with formular

[Michael_at_Graz]

Hello Everybody.

I want to set a formular for increase/decrease steps, but this looks impossible.

Background:

We use appsheet for our warehouse and we have products with different packaging sizes.

Example: Drink 1: 24 pieces, Drink 2: 12 pieces, Snack 1: 8 pieces, Snack 2: 20 pieces.

If i want to take 2 packaging sizes of the drink 1, i have to put the amount of 48 in the amount field.

If i can set up a formular, i could click 2 times on the plus sign, and get 48 pieces.

Actually, i have to show the packaging size as a shown column in the form, that my employees know the right packaging quantity without switching everytime to the articel view.

It would be great to set a formular, to automaticaly check if there is a packaging size saved by this product, than use this step to increase and if nothing is saved, than use normal steps.

Actually, i only can add a number to the increase/decrease steps and that infect all products.

Alternative, i can set up a valid if formular and a notification if its not falid, but that its no nice way, cause its like bingo if you get the right amount of packaging size.

Maybe you can add this feature in the future, this would be very great.

Many thanks and nice greets from austria.

[alphacp]

 not have a pack size and a quantity? If the pack size from Drink 1 is always 48, then just select the quantity of these packs. You can still show a virtual column that is (packsize * quantity) if needed

[TeeSee1 · Accepted solution]

Suppose you have the following

• PRODUCTS table with ID, Package Size
• ORDER DETAILS table with PRODUCT ID(ref to PRODUCTS), ORDER QTY in Packages, ORDER QTY in Pieces

Create an action(s), Data: set the values of... , on ORDER DETAILS table with

ORDER QTY in Packages = [ORDER QTY in Packages] + 1 // -1 for decrease

The App Formula for ORDER QTY in Pieces should be

[ORDER QTY in Packages] * [PRODUCT ID].[Package Size]

[Michael_at_Graz]

many thanks for your answers.

i understand your intension but i think i have to apply a second field, cause some customers need a package size like 24 pieces and other customers only need 20 pieces and i will give them the option to just purchase this 20 pieces. so i will add 2 fields, one with the package size to add and one with pieces to add.