I use Airtable to track my weekly services for a company. I would like to automate invoicing by also attaching price associated with the service. For example:
Service A = $60
Service B = $240
Service C = $70
Currently, I filter all of the services in the table (filter specific service) and paste a price to all the entires. I repeat this with each service type.
What I would like is some kind formula or something whereby I can set what Service A, B, and C cost so that the price automatically appears in the field next to the service column. At the bottom, I can see the total. I will then use this for invoicing.
Maybe creating a new Table where each service rate is defined and then somehow connecting this rate to the “Service Log” table?