Creating Data entry with input from another source

[jannis.kuhrt]

Dear all, hope you can help!

I have a list of products in a repeating group which I can select and push into a custom state.

The respective database looks like this:

The selection made is going to create an order into another database called order:

The name of the product is going to be shown in the order but I dont get the price into that.
Tried it like this:

How do I get the price of the product into the order? Any thoughts?

Best
Jannis

[leo.heyres]

Hi Good day Jannis,

i believe you already added some constraint on your do search function. what i suggest is you can add “:first item”. It should look like this now “Search for products:each item’s Price:first item”

Hope this help if not let me know.

[jannis.kuhrt]

thanks!!