Hoping you can help educate and guide me to achieve the following:
I have 3 collections: ‘Properties’, ‘Rooms’, ‘Items’.
When a user creates a ‘Property’, I would like that new ‘Property’ to have specific default ‘Rooms’ and a user can add more custom ‘Rooms’ if they want.
When the new ‘Property’ with its default ‘Rooms’ is created, I would also like each default ‘Room’ to have specific default ‘Items’ in them.
Is this possible?
I tried using a lot of the different relationship options and the automatic population but hit a bit of a wall. Any knowledge out there on how to achieve this?
If there is one default room for one property and one default item for one property with the room then you can make the button as a list and filter it for the default one and set the maximum records section to 1.
If there is three,four default rooms for one property and three,four default items for one property with the room then you need a countdown with a list to add them all for the record
Wow wow wow. So helpful these videos thank you so much!! Using countdowns is very clever and a solution I would have never found! Thank you so much.
So I got it to work for adding the Rooms to a New House but struggled a little bit with adding the Viewing Items to the Rooms within the House…
I tried adding another custom list to the same page but that didn’t work. Maybe my data structure is wrong? Do I need to go to another setup page for that?
OK so what you need is to show the viewing items for that clicked room in the property!
What you need to do is add some viewing items in the viewing items collection and select the default rooms! Something like this :
So create viewing items for the default rooms!
Then after adding the default rooms for that created property from the list with the countdown you can add a list on the Rooms List screen and connect that to the Viewing Items collection and make the filter from All Viewing Items to Current Room > Viewing Items!
And also I see that you have a Many to One relationship property between the Properties collection and the Rooms collection! I believe the relationship you need is the Many to Many relationship property!
And in the countdown that is inside the list for adding the default rooms for the created property add another action to update room for add that proeprty. So you woud have two Update actions!
Update Property - Add Room for the Rooms relationship property ( Many to Many )
Update Room - Add Property for the Properties relationship property ( Many to Many )
Wow Dilon, this is amazing and so clear! Thank you so much. I had a suspicion the data structure I had wasn’t quite right!
I’ve set everything up as you outlined but I keep getting an “Action cannot be completed” message. I tried setting the countdown timer to longer but that didn’t seem to work either Am I missing something?
Again thank you for your time so far, I’m new to the platform and trying to figure it all out
Hi @dilon_perera,
I have a client who wants to allow his customers to either create brand new restaurant orders OR create a re-order – that is, create a new order based on the items and quantities of a previous order. Similar to how Skip the Dishes offers the option for users to view past order history and click on the Re-order button. How do I do this so that the client clicks on a Re-Order button once and all the items and quantities from the old order are copied into the new order. Many thanks in advance. Mary
Hey @dilon_perera, I managed to finally figure this out. I had the wrong relationship between new order orderitems and old order orderitems. thanks, Mary
h
Am I missing something?