Hello, I have 2 tables, clients and tasks. Each task has a linked record field to the client. I want the automation structured so that when Task ABC is Complete, the linked client's stage (stage is a field in the clients table) updates. I am struggli...

Is there a script/formula I can use to extract zip files as separate files and have them saved in another field?

I have a table that is creating a record for each client that completes a form. I have another table on the same base which is a synced google drive table with all client folders. Is there a formula/automation I can use to link the "open in google dr...

I have the primary field set as a formula right now as CONCATENATE({Client Last Name},', ', {Client First Name}). I want the formula to include the spouses name after the client's name if the marital status (separate field) is married. What would be ...

Hello,I have an automation that updates the Invoice Table paid column with a checkmark when we receive a Payment in the Payments Table with a matching invoice number. We now have noticed that clients may pay the invoice twice. To document this, I wan...