Mar 28, 2023 07:58 AM
Hi all,
For a table as shown above, where only field "item nu" and "Scale" have distinct values for each row while other fields share the same information, how can I automatically fill in the other fields with the common information as shown below? I understand that I can select and drag, but when it's a large table imported from google sheet, is there anyway to automate this?
Another question is, if I want to keep one row for each SKU which will put multiple item nu/Scale in one cell, is there anyway to still keep the one-to-one connection between item nu and Scale?
Thank you all in advance!
Mar 28, 2023 10:46 PM
> how can I automatically fill in the other fields with the common information as shown below?
I would:
1. Select the value that I want pasted into the column
2. Click the field header, which selects the entire column
3. Hit CMD / CTRL + V, which should paste into the entire column
And I'd use filters to hide whatever records don't match what I want to paste
> Another question is, if I want to keep one row for each SKU which will put multiple item nu/Scale in one cell, is there anyway to still keep the one-to-one connection between item nu and Scale?
Hm, so the SKU doesn't have a Scale value, only the "Item Nu" records have a Scale value? If so, what if you moved the "Scale" field to the "Item Nu" table, and then used a lookup field in the SKU table to display the linked Scale values? Would that work?