I am encountering an issue with dynamic input handling in one of my Retool applications and would appreciate your assistance in resolving it.
Issue Description:
I have set up a BigQuery query in my Retool app (Query user's offramp history), which works perfectly when I hardcode a value (specifically for the email field). However, when I try to dynamically pass the input from a text input field ([emailInput1]) using {{emailInput1.value}}, the query does not return any results in Retool, despite the fact that the generated query appears correct in the Debug Console.
The query runs successfully when executed directly in BigQuery and also works in Retool when the value is hardcoded.
Setup Details:
• Text Input: {{emailInput1.value}} (where users input the email).
• Button: [button1] (triggers the query on click).
• BigQuery Query: [Query_User_Unmatched_Crypto_Transfer], which includes a filter based on the email input.
• Issue: When using the dynamic input for email, no data is returned in Retool, despite the Debug Console showing the correct query being generated.
Troubleshooting Steps Taken:
• Verified that the {{emailInput1.value}} is capturing the correct input using console.log.
• Checked the query permissions and tested it directly in BigQuery.
• Ensured the query is being triggered properly via the button’s event handlers.
• Attempted to disable caching for the query and run without it.
• Tested with hardcoded values, which works as expected, but dynamically passing the input still does not produce results.
Could you please help me identify what might be causing the issue or if there are any additional steps I can take to resolve it?
Thank you for your time and assistance. I look forward to your response.