How to write to 2 different sheets in one edit form?

If someone has an account that is not filled yet, I want them to both fill some fields in their user sheet (name, address) as some fields in the sheet of the product they are ordering. How do I do that? All in one form.

Might need a little more context to provide the best answer, but essentially you’re probably going to need to do a Set Column Values via a Single Relation.

But, your question sets off a tiny red flag for me - are you adding/editing the same values in 2 different tables? If so, that seems like un-necessary redundancy. You might be better off just setting the values in one table, and then use a relation + lookup to access the data from the 2nd table. Hard to say, without seeing more.

No, different values.
I have a shop. The site is open to everyone.
If people want to order something, I need info:
A - Info about the user (where do you live, how can I connect you)
B - Info about the product they order (size, collection date, etc)
A and B go into different sheets.
As a non-coder I ask myself why can’t I decide per component which sheet I write the info to?
And now that doesnt seem possible, whats the best way to accomplish this :wink:

So are you adding new rows, or editing existing rows?

Sounds like you’re adding new rows, in which case the simple answer is to use an On Submit action which adds a row to your second table.

Both :wink:

Editing existing row ( The User Profile is existing rows, because when signing up the user only has to add email.)
Add new row because the existing user buys a subscription.

Okay. So just use an on submit action to add a row to the 2nd table.

Yeah, that’s not the problem. That’s more or less default.
But besides that I want the user to fill its profile that for starters only has email address because that what Glide asks when signing up…

To the user it won’t matter and feel logical: I ask to give some personal details (adress etc) and some product details (size, color).

To me it would feel logical If a Glide admin could easily add required fields by choosing components to the user profile page. If that was the case, I would be done :wink:

You’re probably going to need to write those user values to the order table, and then you can use a set column action on submit to pass them to the user table. You will probably need a single relation from the order table to the user table to accomplish that.

Thanks, If I start from the other side, I need that info like address, city, age, etc on the user sheet to be able to send and contact. What is the way to let people add that when signing up? Because they have to leave their email anyway, a few fields extra is no problem. If I have that, the rest is doable for me.

You can create a simple onboarding screen that asks for that information. Set the visibility on that such that it only shows up when those User Profile values are empty.

Or before they can even place an order show a button to complete their profile, which can take them to a profile edit screen. Once the profile is complete, only then show the button to place an order. Theat way theyr aren’t forced into completing their profile and can browse freely until they are ready to start ordering. Then the only way to start the order is to have a completed profile.


It’s similar to what I do here. You can’t add anything to the cart until you sign in. I use the same button but with a custom action that forces you to sign in. Once signed in, then the button will allow you to add to cart.

I don’t remember, but I may have something in there to pass in details from the user profile, or let the user change them while completing their order. I don’t remember if I did anything to actually save updated values back to the user profile.

So my example may or may not contain pieces of both scenarios.

The site is open for everyone, you need to sign up when you want to buy. Maybe I don’t understand Glide right, but it feels like one step too much?
Say people want to buy. I will then send them to the sign-in / up page. And I will ask there for their email-address. Submit 1.
After that, they get a code. With that code, they can log in.
Of course, then I can ask them for more info. Submit 2.
After Submit 2 they can order their product.

It feels like one submits too many? Every step too much is a chance of loosing people.

Is this what you mean? Do I need two steps or can I do with 1 but miss the point? :wink:

I’ll have a look! Thanks!

I call it a shop, in a way it is, but in the end it is a subscription service where people have to pay for.

1 Like

Thanks @Jeff_Hager and @Darren_Murphy !
I allways feel guilty asking questions and wasting peoples time.
I am looking forward to Glide Support As A Service :wink:

1 Like

That’s fine, I think Jeff & I both enjoy answering questions and helping folks.
Quite often, the biggest challenge is getting a clear understanding of what the person is trying to do. Once we have that, the answer is usually pretty obvious :wink:


But I’m serious about Glide As A Service too :wink: Often I don’t have questions, sometimes I have a lot, I would love to pay for a subscription service with answers when necessary. But then helping becomes a business of course :wink:

1 Like

I’ve always said to myself that if I start using glide to make money, then it will no longer be fun and will become a commitment. What I use it for is largely personal. My primary “customer” is my girlfriend. :wink: Everything else I do I’d consider a hobby. I like helping out because it keeps me current on features and helps me learn new tricks. Right now I have no commitments to help anyone, so I can pick and choose based on my schedule.

1 Like