Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Sales & Purchases

Topic Labels: Formulas Sync
779 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Eugenek
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone,

I would be grateful to everyone who offers solutions

I have two linked tables:

 

Problem 1  Resolved

I need a formula for the "Status" column that will display such statuses:

image 1.jpg

 

Problem 2

When I add a new record to the "Sales" table, I need to make sure that the product does not appear in the list if the entire quantity is sold:

image 3.jpg

 

Problem 3

When I select the quantity of products in the "Sales" table, I need to make it impossible to select more than the quantity in "Purchase" table:

image 2.jpg

Thank you.

1 Reply 1
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

Problem 1 and Problem 2 are possible, problem 3 is not. However, we can likely add a helper field to instruct the person entering the info to only sell up to a certain number.

I have some time today if you want to book a call here and I can quickly help you - https://calendly.com/d/4bv-hfn-5pc/one-off-meeting