Editing existing database records

Need help Database
1

I’ve built a screen the is used to enter a new record of data (database is using SQL Connector API, not Bubble database). This same screen is used to also ‘edit’ an existing record that is selected from a RG. Adding a record is fine. But when editing an existing record, I am populating the same popup elements using a condition that checks if a State is set to a specific value (where State 'Mode = ‘Update’), which is set via a workflow attached to a button calling this pop up from a RG. While I am able to set the value from the selected RG item for some fields (by saving the Item Index of the record in the RG and calling that to get the field value in the RG ), I am unable to do so for dropdown fields that are either populated from an API call or a Dynamic dropdown (although static dropdowns work).

Below is the RG used to call the popup to either add or update a record:

An example of where it works and populates are below:

image.png1392×757 101 KB

Below is one of the dropdowns that are dynamic, but doesn’t allow me to pull info from the GR item selected:

image.png1399×727 101 KB

I’m unclear as to how to get this information. Any ideas?

2

Anybody know an answer to this? Holding me up in finishing this project. If no one else knows, can I get help from the creators? It’s been 5 days.

3

Might be worth grabbing some time with @copilot or the folks from Airdev or Bubblewits. I don’t have any experience in this area, but some of those other folks might.

4

The trick to get this info is to have a group inside the RG cell which references the values you want, then the dropdown can refer to the group. The group doesn’t need to be a parent of the dropdown.