I am feeling like I am doing a lot of double manual entry. I started with the Product Catalog & Orders template, but I am entering the same information in both Client order & Order Line Number tables.
Is there a way, that when I add a new Client Orde...
Hello! I am trying to do a sum of days! Here is what I have
IF(Delivery=BLANK(),"", DATETIME_DIFF(Return,Delivery,‘days’))
I am getting a number output of the difference of days, (IR: 2, 7, 14) however they are not recognized as numbers because they ...
Hello! So I have a table that I am trying to run a formula to the primary field.
Here is what I have:
IF((Retailer = “Rachel”),("#" &{Order #}) & “-” & “R”) & IF((Retailer = “Mandee”),("#" &{Order #}) & “-” & “M”) & IF((Retailer = “Nichole”),("#" &{O...
On my Inventory Table, I have my primary field as Name of Product and a lookup field of Sales Team Members that have sold that specific item (linked from a Multi Select)
Is there a way that I can then take that Sales Team Member column and know how m...
Ok thank you! I may have to rethink the whole way I’ve done this. When I add the number to the linked column, they come back as unnamed after I “create” the record.
Yes! When I do the lookup feature in the Order Line Items, it’s empty and won’t show anything I update. I did verify that my 'Linked fields" in Order Line items shows “Client Orders” and vice versa.
So I’m adding the order number in Client Orders to ...
ahhhhh Thank you so much! Got it! Any chance you have the magical answers for this next stump?
I am trying to break my orders down by size quantity ordered. (I am using the sample Product Catalog & Orders - Schedule)
From the Order Lines Item Table I...
This! I’d love to follow up with this! I’m trying to sort what Sales Team sold what inventory. Primary field Inventory name, Linked “retailer” field with salesman name, the retailer table is made from the total sales table where each salesman is also...
