My data source is a google sheet with multiple tabs, each tab has a table which has its own slice, all the tables contain a column called โNext Areaโ. This column is a Enum type, a user would choose the next area that the product will go to, and this is displayed in the deck.
The issue is that this change only is shown in one slice, so if the product is in another slice this information is not shown. I need to be able to update this column in every sheet once it has changed in one slice so we know where the product is.
I tried to use an action however this doesnโt update the location automatically (i.e. without user intervention). Is there a way to do it?
Hi @TY_Car
Welcome to the community !
Is it possible to use virtual column for your needs ? As it is calculated on the fly, there wonโt be any need to create an action just for update purpose.
For reference:
How would that work?
I invite you to read the document in my previous post.
In short:
Sorry I may have not explained the problem very well. The new location has to be inputted by a user from a list. To update the information a user shouldnโt do anything else. That is why I wasnโt able to do it with an action as it required an action by a user to update.
From my understanding the virtual column can only be a formula and not a Enum, so I donโt this it would work
You explained it very well, I misunderstood.
Correct.
What I still donโt get, is:
Slices, based on the same table, are each just a part of that table.
Someone modifying an information (statusโฆor area) will impact every slice, provided these are based on the same table.
Can you tell us more about your table/slice structure ?
The product goes through multiple processes, so like inspections, repairs, quality control and so on. So each table and slice corresponds to a process. The only thing that the tables have in common is the product ID
OK.
Just asking: what about an action that will update product location instead ?
This way, you retrieve it in each slice with a virtual column, with the expression:
[Product ID].[Location]
Iโm not sure if I understand. The product location would be updated by an action in every slice? So the user will have not input for it?
Well, there are always various ways to achieve the same thing, but I was thinking about something like this:
This may work, but how can I implement it so that it updates all the slices at once?
This is it: it isnโt about updating all slices, but just about updating one value in the table Product.
And then, use a virtual column in every slice to read the value currently stored in the table Product, through one VC per table.
I think Iโm facing an issue due to barrier language, my explanation doesnโt seem to make sense.
I allow myself to call on @Steve, @Marc_Dillon, @Suvrutt_Gurjar on rescue: maybe my idea is not correct, or I donโt succeed into explaining what I have in mind properly
If youโre keeping a record of the same โthingโ in multiple spots, then I would say you need to rethink your whole data structure.
To solve your current issue, youโll need to execute a group of โreference actionsโ (Action of type โexecute an action on a set of rowsโ), one for each other Table, where in the โreferenced rowsโ youโll provide a FILTER()
expression that retrieves the matching record from the particular Table.
Youโll also need an Action on each Table that sets the appropriate values. Iโd recommend using INPUT() for each of these Actions, so you can pass the origin value through each reference Action.
You can execute this Group with a Bot, or with a Form Save.
As Aurelien said directly above, this has nothing to do with Slices.
But again, I highly recommend re-thinking your data structure.
Thanks @Marc_Dillon
Thanks @Marc_Dillon and @Aurelien for your suggestions
User | Count |
---|---|
35 | |
31 | |
30 | |
20 | |
17 |