When clicking NEW (app generated) in related ...

(Andy Hambleton) #1

When clicking NEW (app generated) in related deliveries by customer. My app used to auto fill the same customer name in a new delivery form view. It now leaves it blank for me to search the customer name again. Have I toggled something off?

(Steven Coile) #2

Make sure the App formula for the related deliveries by customer column uses the ref_rows() function. That function provides the magic that auto-fills the customer.

(Andy Hambleton) #3

+Steve Coile Hi Steve, that fixed the problem. It stopped the auto fill when I organised the list of related deliveries into reverse order (=ORDERBY(REF_ROWS(“Deliveries”, “Pub”),[Delivery Date],True)). Do you think it’s possible to have both working?

(Steven Coile) #4

@Andy_Hambleton I don’t know for sure, but I doubt it. :frowning: