Auto populate form fields from a relation

Hello fellow Gliders,

I’m having an issue where I cannot get the form to autopopulate the payments table from the suppliers table.

I’ve got a payments table which generates contracts and I want to auto populate the content from the suppliers table (name, address, email etc).

I cannot get this to work as it stands.

What I need this for is to autogenerate invoices via signwell. At the moment the users are manually typing in the supplier details and that all works as expected. it’s just getting the details to populate in the payments table I’m having problems with. Signwell needs the data in google sheets so I cannot take relational data which is only stored in Glide.

Many thanks.

How does the Payments row get created? You can probably have a setup when it gets created to fill out those pieces of info.

If you have the Suppliers in Google Sheets as well, ARRAYFORMULA/BYROW are other options.