Hi there, I am so sorry I am really knew here.
I am trying really hard to build an app for my company which has 8 different pubs so I’ve entered all their information, links, menus, social media, everything, and while I am doing good only 2 things i am having a bit of trouble which is to filter the various kinds of Menus (Food and Drinks) per respective Pub and to make the Review Page for Each pub to accumulate new reviews together with old ones instead it’s just letting me edit the same review or in this case the first which is at the same time the last review, so if I edit that review and submit if I go back to add a review I will only be able to not add another one but to edit the one I just wrote.
Please if anyone could guide me on how to do this, that would be great and much appreciated.
Can you give some more information/screenshots about how your data is structured in the data view?
Suggested simplistic data structure without knowing much about your desired app:
- A table with all of your pubs, and their metadata (social media links, links, information, etc.)
- A table with all of your menu items, that includes a column for the associated pub’s Row ID from the pub table in #1 above
- A reviews table, where users can submit new reviews, also including a column for the pub’s Row ID, again from table #1 above
You can present the list of pubs in a collection, and when the user selects a pub, they will receive a view (possibly a collection) of all menu items for that pub, filtered on the pub ID.
There can also be a list of reviews, filtered on the same pub Row ID as well. A new review will come from a form screen after pushing the Add Review button, and adds a new row to the Reviews table, also storing the pub’s Row ID in the column explained above. New reviews will display in the order you configure.
Hopefully that gets you started.
Hi there,thank you so much for the time you spent to reply to me.
I am sending screenshots of all the tables I created in Data View.
So basically I need to build an app with the first screen with the company logo and a welcoming message and a clickable button to take the user to another screen with a list of the company 8 pubs using a thumbnail of each of them, clicking on any of them would take the user to that respective pub screen, and on each of those pub screens it would have buttons for Food Menus, Wine & Drinks Menus, Promotions, Events / What’s On, and Social Media Links ( I think to add the possibility to add Customer Reviews is too complicated for me so I gave up on that one ).
So when the User would click on any respective pubs screen buttons for example Food Menus button, it would take the user to another screen where he has buttons with the link for each Menu ( ex: Seasonal Menu, Sunday Menu, Kids Menu, Dessert Menu, etc…), the same for the Wine and Drinks Menu as well as Promotions, Events/What’s On and Social Media Links.
I think my biggest issue is to create relations so as it would filter data according to which respective Pub screen I was in, maybe you could help me solving this, that would be really appreciated.
Kind Regards
Ricardo
Okay thanks for sharing. I would suggest making the following changes to make your relations slightly easier, and this will help with the reviews aspect later.
You already are using Row ID in your pubs table, good start. Since your data is somewhat static, I would suggest eliminating the pub ID field (unless you need it) and instead using the Row ID from the Pubs table there. Then your tables Events, Menus, and Promotions can use Lookup fields based on a relation you create from the Pub table Row ID. You could also move the social media links into the Pubs table as columns, which allows you to display those directly on the Pub screen.
On the pub screen, you can display a static list of buttons (or use a collection) to link to each of the various areas you may want to explore, such as the menus, promotions, events, and eventually reviews.
Let’s start with a first step of replacing the Pub ID (unless you need it, then just add an additional column) with Row ID from the pubs table, and then creating a relation from the Menus table that checks if the Pub Row ID column matches the column for Row ID in the Pubs table. Then you can create Lookup columns for the name and other data. Technically, you can use your existing Pub IDs for relations if they won’t change, but since they are integers it’s possible for that to cause errors if a numerical Pub ID is created incorrectly in the future. The Row ID will always be unique to each Pub in the pubs table.
Second step would be to add the social media links as columns in your pubs table and eliminate that table. You can use an Action Row or Links component to display them on the pub screen.
Will see how that goes and let you update here.
Right, and how do I create a relation from the Pub table Row ID to create a Lookup field for the tables Events, Menus, and Promotions, sorry I still don’t get this relation thing
So I want to show only The Bold Forester Menus Links (image 1) when I click on that Pubs thumbnail (image 2)
Follow the steps in the Relations guide linked by @Jeff_Hager , and then you can use the Lookups guide to get the pub name and other fields you care about into the menu, events, and promotions table.
When you present your view, now that you have the Pub’s RowID in each of those tables, you can use a filter to filter only the results you want to show for that pub.