Hello everyone!
Quick questionโฆ So I have a Customers table (very simple, just the customersโ names) and a Sales table which has a date, the customerโs name (which comes FROM the Customers table) and the price of the sale.
Basically what I am trying to do, is that whenever I add a customerโs name to the Customers table, this new name is reflected and available for selection when I go over to Sales.
See what I mean?
Is this possible?
By the way, in the Sales table I have the customerโs name set up as a LIST and the formula is =CustomerList[CustomerNameColumn] which makes sense in my mind, however the list is not reflecting the newly added customer.
Please help me out.
Thank you!!!
Hello @dejhantulip, welcome to the appsheet community !
What you want to do can be done using references, please check out the following link:
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |