Hi everyone, sooo I’ve managed to create a menu ordering app. At the moment a user can view my menu, select their order which goes into a basket and then they can submit that order. I then can see what they have ordered in my order table.
However, their order comes through as a json and even though I can see what they’ve ordered, it’s a little hard as it’s all in json format.
Is there a way to make it easier to read?
Also is there a way of adding an order confirmation of their latest order to their user profile page so that when they’ve placed their order they have a screen that they can show when picking up their order?
Please let me know if anyone can help? The app is meant to go live on Tuesday.
Thank you so much.
All the best,
Anna
Hi Anna,
You could use a helper table to display your orders.
Look at this video by @Robert_Petitto.
Hola!
Maybe using a couple of JSONata commands you can get what you want.
Here you can test and learn a little more: https://try.jsonata.org/
Saludos!
Hi Hassan, thank you so much for responding. I actually followed this video from start to finish to create my app however keep getting stuck on the last but where he shows putting the order in the user profile. I have done everything he has but it wont give me the option to filter by view - name (44.22 in video). I think its because when creating my json name collum it wont give me the option.
thank you gvalero! how does it work? is it kind of like a translator? will i be able to automatically input the data into a sheet than i can then send to my chef for example so he knows what orders have come through
Hola de nuevo!
Can you put some examples (screenshots) of your JSON data in order to test and get what you want to?
Show/explain us a little more the expected results
hi! so i dont think its actually json, im sorry! I tried copying into that website and it failed. its data from a multiple files column. i need it broken down into separate info so that i can see what Main dish, Salad & Dessert the user has ordered (along with a timestamp which i have and their name/email)
does that make sense?
the info reads:
“{”“Name”“:”“Dessert 1"”,““Description””:““A short description of the item””,““Allergens””:““allergens: “”,”“id””:““BxsBtMwpSpKlgPJay-2LqQ””,““timestamp””:““2024-08-10T10:43:03.725Z””,““Category””:““Desserts””}“,”{““Name””:““Salad 1 “”,”“Description””:““A short description of the item””,““Allergens””:““allergens: “”,”“id””:““67OruJs.T7Cqf64oEvJZMg””,““timestamp””:““2024-08-10T10:43:06.037Z””,““Category””:““Salads””}"
Ive created single value columns for each of the menu options as rows to be able to see it easier but its still not clear. I know what they have ordered but id like it without the “name” etc bits. this is probably completely wrong
I think your best bet would be using a joined list column to join all items in the JSON, then use JavaScript to transform that to a HTML table, then display it using the rich text component.
@ThinhDinh Could you please share the JavaScript code for this? I need it for my app as well
