Hi, Say I have:
2 data collections, one being products, and another being orders. on my order collection, i have a reference field to the products table for the product in the order.
I have one data set on a my page and I have a form with a dropdown field and a text box. The form posts to the orders table, so that's the dataset it's connected to. the dropdown is of the product names, which are referenced on the orders dataset. I want the text box to show the price of this order (taken from the products collection). Is this possible without code?
Seems like it should be, but I'm not able to do it because I can't filter by the reference field.