Hi everybody,
I would like to know if there is a possibility for a field to be calculated automatically according to some conditions. For instance.
1. I have the sallers table and the field [CALCULATED] yes/no type.
2. I have the order items table which has the field [UNIT_PRICE]. This field is currently receiving a formula that comes from the spreadsheet which fetches the unit price value of the product from the [PRICES] table.
What I need?
1. Automatically calculate the price of products when the CALCULATED field of the sallers table is equal to NO. When YES, allow the seller to enter a value in this field.
Look my table order items to see the formula I've done.
The complete formula is:
VLOOKUP(RC[-6],'PRICES'!R1C1:R10C31,MATCH(CONCATENATE(RC[-5]," ",RC[-2]," ",RC[-4]),'PRICES'!R1:R1,0),0)
It is possible?
Any given column can be populated via only one the following mechanisms:
it sounds like you need something like the following:
Sorry @dbaum I didn't undertand you. Could you exemplify?
Here's a general pattern you can adapt to the specifics of your app.
Another approach could be to stick with a single [UNIT_PRICE] column, but not use a spreadsheet formula:
I will try and tell you if itยดs runnig
Dear Mr. @dbaum ,
I'will need a little bit of you. I am assuming your final suggestion, but when I tried to adapt the formula I saw this error:
Vendedores = Is the same of Sellers table;
[REDE] = is the equivalent of the [CALCULATED] field, as informed previously. The field [REDE] is of the yes/no type.
Preรงos = prices table
hpedidos = order header table
dPedidos = order items
My Sellers table:
My hPedidos table
My dPedidos table
How can I fix this?
โ
I've tested this formula instead of:
IFS(NOT(IN(USEREMAIL(), SELECT(Vendedores[EMAIL],([REDE] = TRUE), TRUE))),VLOOKUP(RC[-6],'Preรงos'!R1C1:R10C31,MATCH(CONCATENATE(RC[-5]," ",RC[-2]," ",RC[-4]),'Preรงos'!R1:R1,0),0))
However, the error persist once the table PRICE has many coluns as follows:
Price table:
โ
Your verbatim formula from the spreadsheet won't work as an expression in AppSheet. You need to adapt your spreadsheet formula that uses spreadsheet functions into an AppSheet expression that uses AppSheet functions.
Mr @dbaum Good Evening,
Any ideia to how use it in this spreadsheet formula?
It is an array, but I have no ideia of how to convert it.
No. I don't know enough about the data structure of your spreadsheet or you app to parse your spreadsheet formula or draft an expression for an App formula.
In case you haven't already found it, here's a great guide to using many AppSheet functions that are likely relevant to your need.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |