New to app sheet. Want to display inline child items and update one field in the child

[Julie_Wills]

Hi folks

I'm new to Appsheet (although I have used Glide before).

I'm trying to create a checkin app for people who have purchased tickets for an event.

I have two related tables:

An Order table, with an order ID, and details of the purchaser, in which I want every visible field to be searchable.

A ticket table, also with the order ID as a key and Ref type, and details of the specific type of ticket bought, and how many tickets were bought.  None of the data here should be editable, except for the number of tickets that have been used up.  (And the user should then see the number still available to use.)

What I want to be able to do is to search for an order (by order number, but also by name of purchaser, post code, and other information about the order.

I want to display the resulting order or orders, and select the one I want, which should then display the order info, together with inline details about the tickets bought on that order, and then be able to check them in. 

Most people will arrive all together to use up all of the tickets in the order, but occasionally only some of them will arrive together, with others to follow later.  So I want a quick way to say all of the tickets have been used, but also a way to say that only some have been used, so that the other members of the party can arrive later.  

e.g. an order may be for 4 Adult tickets, 2 Under 18 tickets, and 1 Under 8 ticket.  When people arrive at the check-in desk, I want to be able to update the order to say they've all arrived.  But if they don't all arrive together, I need to be able to say, for example 2 adults and 2 under 18s arrive but the other will follow later.

I'm falling at the first hurdle.  I've set up Order ID in the ticket table to be Part Of the Order, but I'm struggling to even see how to list the tickets in the order, much less update how many of them have been used.

I need to get this done really quickly.  Can anybody please help?

Thanks!

[WillowMobileSys]

You should see, in the Order table, a column named "Related Tickets" or something to that effect - its based on the actual table name.  In your Order views, you need to add this column to the field list.  This column should then, by default, show as an Inline table of the tickets associated with the Order.  So, if you add this column, Save and then open an Order row, you see the "Related Tickets" Inline table with rows populated with the Ticket details.  If not tickets are yet added, the the table should reflect zero rows and show "No Items".

I hope this helps!

[Julie_Wills]

Thank you for that. 

Yes, I've made some progress since I first posted, so can now see the information as parent (order number, Name, partial email address and postcode) and child (ticket type and quantity).  

I'd like to pretty it up a bit now, and add some better functionality.  

Order info and tickets

The Thumbnails (2 Sat Child Under 8 and 1 Sat Adult) are the number of unused tickets still available to check in.  The plain number is the number of tickets originally purchased (so before any check-ins, they will be the same).  

I've set that number to decrease by one each time the Check in action is run (the tick icon), so functionally, that's working*, but the action icon is a bit small.  I'd also like to add a ticket image (these are colour and shape coded for each type of ticket, which would make it more visually appealing and also make the ticket type a bit more obvious.  

It's a 3 day festival, and people can buy tickets for the full weekend, just Saturday, just Sunday or just Monday, so we need to make sure we're seeing tickets for the right day.

*I've also discovered a much bigger problem.  My action is acting on the wrong row in the ticket details sheet.  It doesn't matter which action icon I tap on, it always decreases the number of tickets for the first ticket type in the order.  So in the example above, I can't ever check in the Adult ticket.

I've videoed it happening, but can't upload videos here.  

And to make it nicer and clearer to use (if I can get it working properly to update the correct tickets!), the ticket images are stored in a Google Sheet that's been added into Appsheet, but I can't seem to get them to display.

Here's the sheet.

What I'd like to do is to display the ticket image alongside the "Tickets remaining" thumbnail.  But Appsheet seems to be quite restrictive in layouts of what I can display for child items. 

The number of tickets remaining doesn't HAVE to be a thumbnail, so having the ticket image there instead would be OK, as long as I can display the information about the number of tickets remaining somewhere as prominent text.  

It would be great to display "x remaining of y" (I guess I could do this by adding a column that concatenates the information and displaying that).  

Thanks in advance for any pointers, especially for making Appsheet update the correct row of data for the arrivals.