Summary
A workflow triggered from an app set to the staging environment can only pull from the production Retool database — the staging environment is greyed out/disabled in the workflow's environment selector (Cloud instance).
AI Response
In Retool Workflows, an environment appears disabled unless every resource used by the workflow is configured/enabled for that environment. Because the staging environment isn't enabled on all resources referenced in the workflow (for example, the Retool database or a REST resource), staging is greyed out and only production can be selected. To fix this, open each resource used by the workflow and confirm it has a staging environment configured, then add or reconfigure a query so the workflow references a resource that supports staging — the staging option should then become selectable. Note that the environment must be enabled across all resources the workflow touches, not just one.
Sources
Disabled environments in the workflow
Solved thread confirming that a workflow environment stays disabled until at least one resource is configured for that environment, with the exact steps to enable it.
Solved thread reinforcing that the desired environment must be enabled on every resource the workflow/app uses, otherwise it shows as Disabled, and pointing to the 'Configure resource environments' docs.
The Community Team is testing out a new automation. Let us know if it's helpful (or not) by leaving a 
, 
, or 
. Or by marking this post as the "Solution"! Let us know if you have any feedback here. 