No, let’s say I have a Clay Table called Companies, following columns:
HTTP API - Create Company in Database
Company ID Database ( Column from the previous Column)
I have another Users table (Users are associated to companies), with the following properties:
Lookup Company Table (Users.Company Custom ID == Companies.Custom ID)
Company ID Database (This is empty unless the company has been created)
HTTP API - Create User in Database ( Depends on Company ID Database)
I have around 25k companies and 25k users. I want to execute the HTTP API - Create Company in Database and once it’s been successfully executed, I want to write the Company ID Database from Companies into the field with the same name into Users, such that HTTP API - Create User in Database executes automatically, today this can’t be done as I need to go to the Users table and manually click Lookup Company Table to retrieve the value of Company ID Database from the Companies table (once the company has been created in the Companies table) and then click HTTP API - Create User in Database to execute the request.