Multiple users adding and updating records

I saw that Retool has a multiplayer function that allow multiple users to edit the app at the same time. Does this also work if multiple users are adding or updating existing records through the app interface?

Also is this something that needs to be turned on or is it on by default?

Hey @tomm

You can prefare this docs for the multiplayer collobration :
Multiplayer retool docs

5 Likes

Thanks for the reply @WidleStudioLLP, but the documents seem to just talk about multiple changes to the app. What I need to know is can multiple users enter data through the app simultaneously. I am the only person that will be working on the app, but there are several people that will be using it.

Hi @tomm, Multiplayer allows multiple users to edit the same app simultaneously. It does not affect how end-users interact with the app.

With or without Multiplayer enabled, multiple users can interact with the app simultaneously. The only issue could be if two or more users try inserting a record with the same primary key into the same table.

The request that gets processed first will go through, and the other user(s) will see an error like this:

Screenshot 2025-01-28 at 1.37.42 PM

With an update, whichever update was processed last will persist on the record.

Multiplayer is enabled by default on all apps. If we would like to disable it, we can find this option at the bottom of any app's general settings:

Keep in mind that if a user adds a record to a table, the component will not automatically refresh for other users until an action triggers the query set as the data source (this includes the editor's UI). If you need to retrieve those records frequently, consider setting up the resource query for that component to run periodically.

You can find this under the advanced settings of any resource query:

2 Likes

Thank you @Paulo!

You are welcome!

Happy Building. :hammer_and_wrench:

1 Like