- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 31, 2023 03:36 AM - edited ‎Aug 31, 2023 02:45 PM
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:
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:
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:
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 31, 2023 07:16 AM
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
