User-triggered Data Transfer Between Partitions

[B_Reyes]

Is it possible to transfer data between partitions? 

I'm developing a warehouse inventory application involving several physical warehouses wherein items can be transferred between warehouses (just sometimes, not always) but I had to sort each warehouse into a partition of its own due to the vast amount of data.

I would like Personnel A in charge of Warehouse A to be able to transfer items to Warehouse B, preferably with Personnel B allowing the transfer to happen instead of just letting it transfer without confirmation.

Is this possible?

[1minManager]

You're probably looking at the data struture wrong here.  All you need to do it to have a column called [Warehouse] to identify where it is.  Then either use slices or security filters to split it up, using something like [Warehouse]="B"

https://support.google.com/appsheet/answer/10106592?hl=en

https://support.google.com/appsheet/answer/10104488?hl=en

Simon@1minManager.com

[B_Reyes]

Yes, this is actually how the app was first set-up, however, we've reached more than 50k worth of data rows and we had to partition the data, ie. separate them into sheets with identical structures, for app performance to improve. 

[1minManager]

50k rows of data shouldn't cause it to slow too much.  Unless you've also got something like 100 columns.  Have a read of this and if you can't get the sync time down low enough then I sugest you have one of the more experienced Appsheet Devs look at it.  I'd be happy to have a quick 15min session with you, at no cost.  But this isn't supposed to be a sales pitch 😂

Simon@1minManager.com

https://support.google.com/appsheet/answer/10105761?hl=en

[Steve]

---

@B_Reyes wrote:

Is it possible to transfer data between partitions? 

---

No.

[B_Reyes]

Is there no possible workaround for this?