Help

Re: Getting final cost displayed on main table from other tables

594 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Yashwant_Sarava
4 - Data Explorer
4 - Data Explorer

Hello there,

Recently I’ve started using Airtable for my company and tried using everything onto one table for simplicity’s sake. However, I’ve hit a speedbump and I lack the coding skills to figure it out.

Background: I have four tables in total. One is a list of all my clients. Two is a list of all my services. Three are my services categories. And Fourth is the price of each service category.

My client may select several services. I want to find a way to display the cost of the most expensive service on the client page automatically.

Thank you in advance.

1 Reply 1

Hi @Yashwant_Saravanan1,

Welcome to Airtable Community! :grinning_face_with_big_eyes:

First, you should have an Order table (not sure if it is already included in one of the table above). This table must link between your services and your clients. Then in the Clients table you can use Rollup and choose the argument MAX(value).

BR,
Mo