I am creating an app where users / admin can create a post directly from the app similar with a CMS / blog site.
I need suggestions what is the best approach for my scenario.
Admins needs to post articles/products - in this part I already used the form to edit existing post and activated users can edit and delete for new creation of post and it works well.
my 2nd feature is a post that has a pre-populated choices since I am doing a comparison app.
Admins for now - the post will need to have a choices component where they can select any of the listed selection.
ex.
Product 1
choice selection 1
- list 1
- list 2
- list 3
- etc…
choice selection 2
- list 1
- list 2
- list 3
- etc…
text box
etc…
etc…
What is the best approach for this do I need to create a separate sheet that list all the choices. or use the existing sheet for that post where it gets the populated choices using a relation.
then in the app, admins can add an item to the list or select if the item of choice is already in the list.
I am trying to optimize to lessen the row creation for the pre-populated choices. because my initial data will be around 1500 products