Hi All, I just started with Retool Today, and developed a little tracker for symptoms. I works with 2 sheets in a google sheets workbook.
The main sheet/"table" is called Events. I have a collection sourced from this "table" and a setup to let you drill down into the record detail, edit it, then Update the record.
The problem I'm seeing is that when I'm using the "Preview" in the Query Editor and within the design UI, the update works correctly. When I try it in the live app, it shows a Success notification I set up on the query, but doesn't actually update the record. Very odd that it works in designer but not in live app.
How should I go about debugging this? I don't see any run-time loggers or how to set it up for this update query.
Thanks,
Chris
@chriscam85 Welcome to the forum!
Did you Publish the app? Read the following: Releases and history
Hi Scott,
I should mention I'm building a Mobile app. Also, I see publishing is only for Paid?
How can I test this to make sure it works before upgrading?
Thanks,
Chris
Hey @chriscam85!
Would you mind sharing how you're triggering the query? It may also help to see a screenshot of the query itself!
Here's the initial card:
Change the Symptoms selected:
Click Update (performs update query). Get success notification. Performs Read query again:
It navigates back to card list. Still same info:
Hey @chriscam85!
If you move the navigator.back() event from the click event handler to the success event handler of either one of your updateEvent or readEvents queries does the update go through correctly?
If it does, I'm wondering if it might work to add a loading indicator to the button to indicate that the request is being processed and then navigate back to your original page when it has completed:
Kabirdas,
Thank you. This seems to have corrected it.
Apologies on the delay getting back to this.
Awesome suggestion for the loading.
Thanks,
Chris