please help me.
I have 2 tables, one for sales and the other for stock.
The inventory table receives data (customer id and product) that is informed via a bot every time the customer goes through a certain flow.
however, I need this product to be counted only if the sale is made.
In the sales table you will find the customer’s id. and this table is only fed if the customer makes the purchase.
So basically I need a column in the inventory table that asks the following question: if the sales table has an ID equal to the inventory table then 1 if not 0.
A formula can’t calculate based on records from another table unless the record on which the formula is applied is linked to one or more records in another table.
So, are you linking records together? Based on your description it sounds like you should be, but aren’t.
I am not linking the records. because as they are imputed in the table by an external platform, there is no way to predict the id that will appear and link it previously. ;(
Is every single table imputed by this external source? Is it possible to post screenshots of your base setup. You almost certainly can link your records together, manually or via an automation.
each item you select is inserted in that table. however, these items are not counted as sold. will only be counted when the customer completes the purchase.
When the customer completes the purchase, the summary is computed in this table.
Therefore, after confirming the purchase, I want the string “yes” to appear in the stock table in the purchased column.
until the third stage, I managed to do it, but I didn’t quite complete the fourth stage. Could you explain it better?
An update record step will ask which table and which record to update. Select the
[pedidos] table. In the box for record ID, click the plus button then click
Record (from Step 1), then click
insert next to
Airtable record ID.
Choose field, select the
Link field that connects to the
[Estoque] table. Click the plus button and select
Records (from Step #: Find records), then click
continue next to
Records, then under
Make new list of... select
Airtable record ID.
Wow!! it looks like witchcraft. it worked very well!
Thanks for all your support and patience, Kamille.
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.