@zzaras did you end up getting something working for your goal of adding up the "total" column in table1 when the job_number matches the job_number from the jobs table AND the "type" matches "Service"?
For this kind of "is this possible in Retool" question, our Office Hours can be a good option! Consider swinging by if you're still looking for guidance on this 