Hi, im trying to build a website with the help of Airbase (using softr.io). I have a list of companies in my table.
How would i format the data so that:
i can display opening days
i can display specific events that business have on…
for example - a business may offer a drinks promotion on mondays, wednesday and sundays. They may also offer a DIFFERENT drinks promotion on tuesday and thursday. How do i collate the data so that when i use these values within the website it filters the information for the users?
Sorry if this is poorly explained - im not very tech savvy! Thanks!
Try having one table for Companies that is linked to a table of Special Events. Each special event offered by a company would be its own row in that table. You might have a multiselect field for the applicable days of week, a category field (drinks promotion), and a details field (to differentiate between similar events on different days).