So I think I have almost all the data compiled for our production and shipping team. Is there a way to โmoveโ data between โtilesโ? Weโre looking to have it work as independent data only showing in the applicable screen. Not all the data will need to move but the basics would be nice. The boss wants a type of โsend to โโ and have it disappear from โblendingโ and go to โproductionโ leaving the blending tile to only have current blends in it.
If the only answer is slices will I have to make one master form and just filter down for each of the tiles? Right now there are 3 main tables.
Hereโs the main screen we have so far:
Yay, another person building an app for alcohol production! Brewery here, Iโm assuming winery for you, because of โblendingโ?
If by โtilesโ you mean different tables, then moving data from one to another could be some sort of action like โadd new row to another table based on values from this rowโ. However, if it is the same data but just going through different stages, I would consider just adding a โstatusโ column for the stages of production, and setup slices of the one table to show up in your different app views
Hey @Marc_Dillon. Were actually a canning company so we do all types of drinks.
Will the action โadd new rowโฆโ make it not show in the previous record? I donโt want to lose the data as there is a lot of hidden information but I really donโt want to have to reenter it for every step. If I use slices do I need to put all the data in one table and then slice it from there? As of right now I have them in single tables as this is an evolving product. It wouldnโt be terrible to put them all in one but would take some time to rewrite all the formulas within. I guess I just donโt really understand how that works and the โtutorialsโ donโt really help.
Good Idea for the Status column! Are you thinking a kind of ref for that with the slices?
So I had LINKTOVIEW[NAME] for each of the home screen tiles. Now that I made slices and put all the data into one googlesheet page I cant get the slices to show the โaddโ function. Is there a code for this now?
Hi @Dani_Mittler
Check that your slice and original table allow adds.
So both have โaddโ in the settings. My starting tile, if you will, doesnโt allow for a new line to be added but the rest of them do.
Hey all,
So I think I got almost all the โaddโ kinks worked out. Now the boss wants a separate function. Essentially, he wants to control the first โtableโ and be able to make inputs that only he can change. He then wants those inputs to transfer the the remaining tables and informational data only (uneditable). Is there a deep link so something that can be used to push, if you will, the same task id between tables.
I tried a ref but couldnโt get it to push the information between the googlesheet data. Iโm thinking that just making a form and linking to the form may be the best trick?
Has anyone been able to do this successfully?
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |