I am using Google Sheets and I am trying to create a price comparison site. This means that for one product there would be multiple retailers and multiple different prices. The current way I am thinking of approaching this is just to have separate columns and have them ordered 1st 2nd and 3rd but when the prices change this will cause me to have to make quite a manual change to the database just to reorder them.
Is there a better way in which I could structure this?
@Osman You will have a better experience - here, and elsewhere - if you exhaust all available resources before asking other people to solve your problem.
Your question tells me that you’re yet to crack the surface on the topic of data modelling generally, and specifically, there are identical questions on Stackoverflow
Not to mention ChatGPT - you’ll get answers far more quickly
Good luck
Honestly, I wouldn’t recommend using GSheet for this, as it’s not made to have relationships between tables like Airtable or Xano would do.
If I were you, I would switch to Xano and use links between tables.
PS: we also plan on sunsetting GSheet’s plugin, as it’s very limited to create web apps and their tool is not made for this.