Category: Question and Answers
Updated

This solution is summarized from an archived support forum post. This information may have changed. If you notice an error, please let us know in Discord.

Define foreign key drop downs

Issue

I asked if Appsmith can generate a form and automatically resolve foreign keys from constraints, allowing for descriptions to be shown in a dropdown. However, it seems that this feature is currently not available. The Appsmith team has created a Github issue to track this potential feature and asked for an example SQL query and the desired form output.

Resolution

The user requested if Appsmith can auto-generate a form from a PostgreSQL table and resolve the foreign keys from the constraints so that descriptions for referenced IDs could be shown in a dropdown. However, this feature is not currently available in Appsmith. To address this issue, a GitHub issue was created to track the implementation of this feature. The user was requested to provide a small example SQL query and describe the desired form to be generated.