I have a problem that I need some help with. I have looked at a similar problem that was solved on the forum but can’t think of how to make it work for my use case. Hopefully there are some airtable ninjas that will come to my rescue…
My company provides services to clients on their sites. We have about 4 services that we offer that the client can pick and choose from. Ever since the company started we have tallied up the number of times we have performed a service, for example for Client 1 it might be Service1, Service3 and Service 4; and for Client 2 it might be Service1 and Service2 only. Which services we provide are displayed in a multiselect field for that job.
I then have other columns/fields to the right e.g. Service1, Service2, Service3 etc that keep a tally of the number of times we have undertaken that service. Currently we do this manually but I would love to be able to select the serviced provided in the multiselect field and have the autonumber appear in the relevant column.
Can anybody see an efficienct way to do this?