Appsheet inserting tables in postgresql

AppSheet AppSheet Q&A
1

Not sure if this is intended but caught me off-guard.

Until recently I was on the Core plan, but now I have an Enterprise Plus one too.
I added the source for Cloud Database.
For unrelated reasons i was not able to create an new app at this time so I though to copy an app (for this db) from my Core account. It worked.
Then without adding a new source (which I should have), I copied the second app and this one worked too.

And now the surprise: my db had now the tables for both apps. So the tables for the second app were created in my postgresql db for the 1st app.

This can be a real bugger; how am I going to copy an app on this account without getting one of my existing DBs becoming a “host”?

1 Like
2

I think the way to do this is with some careful order of operations:

  1. First make the database for your second app (you don’t need to add any tables, just make the data source)
  2. Connect that new data source to your app sheet account
  3. Make the copy of your app, selecting the new database as its source

I think if you follow that order of operations you’ll get the result you’re looking for.

3 Likes
3

This is a kind of normal behavior when you copy an app and you select the database as a source. If you don’t want to do that, you need to remove the option “Make a copy of the data for the new app”. When this option is set as OFF, the new app starts to use the same source that belongs to your original app.

3 Likes
4

That’s what I did, without data.
Done the right way as @MultiTech said, should be just fine.
Thank you both for replying!

1 Like
5

You’re welcome!

1 Like