Can not save changes made to tables from published app, but can from preview.

[sergey-vin]

Checklist

• I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Cloud
• Data source: built-in BB DB.

Describe the bug

• Any modification to tables (inline or side panel) from published app are not saved unless I go to BB Editor -> Data, and refresh the page. UPD: And now even that trick doesn't work, after i closed all BB windows and tried to replicate the issue. Now save doesn't work at all. I see the changes in app, but not in DB.
• If I open the preview of the app instead of the published one, then I can instantly see the changes applied right away.

To Reproduce
Steps to reproduce the behavior:

1. Go to Data, add BB DB / BB table, fill with sample data
2. Go to Design, generate a table->inline screen
3. Go to Design, generate another screen, this time table->side-panel
4. Publish the app, edit data in inline manner
5. Go to BB editor, Data tab - see no changes
6. Go back to app, edit data in side panel manner
7. Go to BB editor, Data tab - see no changes
8. Try editing changes from preview - all works

Expected behavior
Changes are saved in DB

Screenshots

here we can see the published app (on the right) shows different data compared to what's in DB (on the left).

sometimes refresh on the left side forces the data changes into DB. sometimes waiting ~5 minutes helps. maybe it's an "eventual consistency", and i just have to wait for some time. But then it doesn't explain where the app takes data from. If I reload the published app (on the right), it remembers its own state, different from the DB.

App Export
no.

Desktop (please complete the following information):

• OS: MacOS 14.5
• Browser: chrome
• Version 131.0.6778.140

Additional context
no.

[linear[bot]]

BUDI-9132 Can not save changes made to tables from published app, but can from preview.

[aptkingston]

When using internal tables, the datasets from your published app and your development app (the builder) are separate. This is deliberate, so that you can design your app and make changes to your data without affecting your live app.

When you publish your app the data gets synced between them - so if you want to see your production data inside the builder then you'll just need to publish to sync them. The preview app is still your development app - so it will always contain the same data as what the data section shows, without needing to publish to sync changes.

[aptkingston]

Converting this to a discussion as this is working as intended.