This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I don't know if this is possible .... if anyone tells me to restructure my data, I'm quitting lol I have Orders, Products, and Warehouses table. Using linked records, I assigned various warehouses to products. And then when orders are placed, it's lo...
I have a rollup formula that returns a bullet pointed listed, which works beautifully (supplied by this incredible community - thanks!). I need to concatenate that with additional information though and am at a total loss. This is my current output....
I'm struggling to figure out a solution for scaling views. I currently have a view for each of our districts (which gives me approximately 90 views). They all have identical data/fields with a filter to only see the pieces tagged in that district. ...
I see several posts that are similar to my question, but I haven't been able to find the actual solution yet. I have a database of all our locations, and at any given time we have about 40 pending locations. I'd like to send an automated email to th...
I have a field that has a ton of linked records and I'm trying to format that into a nice list for use in the Pages extension. It's generally coming through with commas and quotation marks separating it. I found this formula in another thread, whic...
Thanks everyone for trying to help out! I opted to add an "orders" table and am doing a lookup from order details to pull the ship status over. I was able to accomplish my goal which for now is just to populate the content in an automation for open ...
I tried this .... and I don't know what it's rolling up, but it doesn't look correct. One of my warehouses should definitely be showing 4 right now, but instead it's showing 2 on the formula ... .
I considered one workaround could be a rollup of the relevant order numbers and then a formula that counts those entries in the string, but I can't quite figure out how to write that.
Thank you for such a thoughtful response! The problem with this is that it's assuming each order only has one item from one warehouse to process. Since we fulfill orders from multiple warehouses, the same order number exists in multiple places - we...
Okayyyy fine. I added an Order numbers table and my order details links to that. The problem I'm running into is that the warehouse still is ultimately tied to the product. So even when it's pulling the order number, the order number is "duplicated...
