Formulas & functions from price matrix

[peebee37]

I work in the field using a 'tablet', hoping to use a form so, Is this achievable or am I waisting time on this?

I suppose the best way to describe what we're trying to achieve is ....

Take any on-line shopping company,

1 Pick the product.

2 Choose the range/colour

3 Enter the size.

4 Generate price.

5 Add to basket.

Repeat 1,2,3,4 & 5 until order complete, then view basket.

Basket contains products and cost. ( a list containing the above )


As I can use 'index & match's find a value from the SS price matrix, I'm struggling to 'ADD' more after the 1st value & generate a basket


I assume because I have all of the above this can be achieved via tables, formulas etc


Again thank you for your time and willingness to help

 

[Monty Norman]

I work in the field using a 'tablet', hoping to use a form so, Is this achievable or am I waisting time on this?

I suppose the best way to describe what we're trying to achieve is ....

Take any on-line shopping company,

1 Pick the product.

2 Choose the range/colour

3 Enter the size.

4 Generate price.

5 Add to basket.

Repeat 1,2,3,4 & 5 until order complete, then view basket.

Basket contains products and cost. ( a list containing the above )


As I can use 'index & match's find a value from the SS price matrix, I'm struggling to 'ADD' more after the 1st value & generate a basket


I assume because I have all of the above this can be achieved via tables, formulas etc


Again thank you for your time and willingness to help

Hello PeeBee37

So basically you need a shopping cart application? Is that correct?
Do you have any code or are you asking us to write one for you?

 

[peebee37]

Hi thanks for your response, yes I need a shopping cart application and have no coding skills.
As like most work stuff they use excel and numbers for most of their applications but most of it isn't linked so I'm taking measurements in the field then back to the desk and loading the info onto more data sensitive sheets.
As know nothing of coding and super keen to learn, can the code be used linking to a value in a SS (can the same coding 'with some editing' be used on other sheets a bit like formulas)

Very keen to get started. Pat

 

[peebee37]

Hi thanks for your response, yes I need a shopping cart application and I have no coding skills.
As like most work stuff, they use excel or numbers for most of their applications but none of it is linked so I'm taking measurements in the field then back to the desk and loading the info onto more sensitive sheets.
As know nothing of coding and super keen to learn, can the code be used to link a value in a SS (same coding with some editing be used on other sheets, a bit like copy and paste formulas)

Very keen to started, Pat