Adding multiple data in one shot

AppSheet AppSheet Q&A
,
1

Hello Everyone!

I have the below tables:

  1. User
  2. Customer
  3. Pets
  4. Service
  5. Payments

Purpose of the app: To add customers & there pet details and schedule appointments based on services required. One pet can avail multiple services.

Suppose if customer is Aditya, and Aditya has 2 pets Oscar & Blacky. So when I add a service, & if both the pets are taking the same service, how can I add it in one shot, rather than adding the service one by one separately.

2

There are a few different techniques. One would be to make the Pets column in your Service table an EnumList type so that you can select one or multiple pets.