Database & Rich Text Input

Hi guys I am putting together a airbnb type site which has been a massive undertaking but wix code has been amazing as well as the database. I need some advice before I add 1000’s of properties please.

  1. I will have 20 or so main fields with the title field being the holiday property name, then I have around 50 or so amenities.
    a) Should I have the amenities as a reference field in another database or just combine it all into one database? Are there any advantages/disadvantages apart from having 100 fields in one database?
  2. Each holiday property needs a description about the property, this needs to be spaced out and formatted. As the client will be never seeing the database and entering each holiday property via an input form can they enter the description with rich text, or what other options do I have here? I have seen this post https://www.wix.com/code/home/forum/questions-answers/rich-text-editor but this looks way too involved for one input.
    Thanks for your help.

Hi,

  1. Seems to me that there’s no harm in adding 50 or so fields, one for each amenity. In the future you should be able to put all these into an Array field, but there’s no ETA for it at the moment.

  2. The suggestion for rich text editor isn’t complex to implement so I think that’s your best shot. Other than that you could use a Textbox to achieve the spacing but not the formatting.

Thanks. How would I achieve the spacing with a text box? The formatting I can do as non rich text correct?