Join tables from different data sources and manage project status with editable column

[michael_editmate]

So I want to build an app that is;

• one data source from my team's MySQL server (data source 1)
• and the other data source from retool database (data source 2)

What I want it to do is;

• a manager checks displayed projects on a table from data source 1
• a manager changes status to the cell of the editable column in the table and saves changes
• saved data is input to the data source 2
• while joined with key value of data source 1 and data source 2

AS-IS

• I succeed to make a query that writes to the data source 2 of selected row in the table
• I failed to input changed value (=status) to the data source 2 (undefined and null)

Anyone had similar experiences before?

Thanks,
M

[ScottR]

Since the status is changed and more than one row can be edited...
See this doc: Write data to SQL databases | Retool Docs

[michael_editmate]

Thanks ScottR, I'll look into it!

[michael_editmate]

Still in trouble after referred Docs

[michael_editmate]

@Kabirdas Any advise?

[joeBumbaca]

Hey @michael_editmate, looks like you are referencing table6.selectedRow.step, but that data is null because the 'edited' data doesn't exist in the underlying table data. As you can see from your screenshot, there are values in table6.changeSetObject and table6.changeSetArrray. You can reference those to get the step 1 that has been entered by the user. Let me know if you have any other questions!

[michael_editmate]

I'm getting it, THX!