I have 2 sheets:
Sheet 1 is a list of product codes & product data, i.e.
PC1 / Name / Description / Colour / weight
PC2 / Name / Description / Colour / weight
Sheet 2 is a list of product codes with their unique serials, from production, i.e.
PC1 / 0001
PC1 / 0002
PC1 / 0003
PC2 / 0004
PC2 / 0005
I’m hoping to build a layout where no product data is displayed, only a search bar, where the serials “003” can be entered, and the relevant product data is displayed, then can be saved to the sign-in account.
I believe this is possible with Glide, can anyone comment on tools/methods to achieve?