So I am banging head against the wall trying to figure out how to display the correct information from the database and I am praying one of the experts here can show me how it’s done.
The problem is this: I am building a site that collects data from a form and then based on that data selects users from the database. At the same time it stores a new “lead” which shows which users were selected and also logs the estimates put forward. The estimates and user information of those shown in the repeating group are saved as lists in a single database entry.
What I need help with is how to show the correct estimate on the user’s dashboard when displaying past results. Everything else is fine, but the one problem I can’t figure out is how to select the correct estimate based on the user who it applies to.
One of the things I tried was to store the User ID in the list next to the estimate and then put on a constraint to only show the estimate that contains this ID and then regex out the correct part. But that doesn’t work.
I’ve included some screenshots to show illustrate my problem better.
The first screenshot shows the input field which I want to populate the value from the list.
The second screenshot show the table where the estimate should be displayed on the dashboard.
The Third screenshot shows a database entry.
Any help will be hugely appreciated as I am really stuck on this!