hi guys,
i have an required related to power table.
i need two columns in a power table one need to be updated from database(using select query)
and other columns needs to be a dropdown data which contains data from another database table.
the objective is to map both the columns.
below image for reference.
For the query that populates the table, simply add a blank column using null as or '' as in your SELECT statement.
MySQL Example:
SELECT `ID`, '' as `DropDown` from some_Schema.some_Table
Then, populate your blank drop down column using a select statement in the configureEditor extension function.
Here is an example:
