Best Practice for creating a single value Role Column?

[Majestic_Intern]

I typically have users press a button which sets the row owner role to “Admin” for example.

Right now though, I am feeding Mighty Form output to google sheets, then from google sheets I used import formula to glide synced google sheet.
What I did was go to google sheets and add a column that says “Admin” and copied it for 500 rows. It works, but feels like a quick fix that takes too many glide rows.

[Darren_Murphy]

Did you have a question to go with this?

[Majestic_Intern]

Haha, well my question was if there was a better way to do it like a header formula ( I don’t know how to use those).

I did figure out an actual fix now though. I edited the form and added a hidden field which updates to “Admin” once the user fills in their signature. This way I’m not wasting 500 rows.

Edit: keeping this open because I would still like to know if anyone has a suggestion or best practice for making a single column the role of the row owner without wasting rows!

[Darren_Murphy]

@Majestic_Intern

Haha, well my question was if there was a better way to do it like a header formula ( I don’t know how to use those).

You could use an arrayformula, but whether or not that is “better” is probably debatable.

@Majestic_Intern

I did figure out an actual fix now though. I edited the form and added a hidden field which updates to “Admin” once the user fills in their signature. This way I’m not wasting 500 rows.

I assume you mean a hidden field in your Mighty Form, yeah?
This seems like a good solution to me, and should solve your problem re wasting rows?

I guess there’s a good reason why you don’t collect your form responses via a Glide Form?

[Majestic_Intern]

Well yeah I never really figured out to make arrayformulas function properly. I previously had a use case where I wanted an auto increment column (1,2,3,4…) that would update every time a row is added, but never figured it out.

Yes, the hidden field completely solved my problem.

Collecting the form responses from Mighty Forms because it will be embedded on a website. I will not be using a user-facing application, just a back-end application.

Also making a long line item (in this case 29 columns) on glide can get a little tedious lol. Also I’m using conditional logic on the form input, which would force me to make a custom form and entry field placeholders on glide.

[Darren_Murphy]

@Majestic_Intern

Well yeah I never really figured out to make arrayformulas function properly.

@ThinhDinh has a very good tutorial on the topic of arrayformulas. It’s quite old, but still relevant, I think.

Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts

Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job.

1/ Definition

Arrayformula is defined as “a range, mathematical expression using one cell range …

@Majestic_Intern

I previously had a use case where I wanted an auto increment column (1,2,3,4…) that would update every time a row is added, but never figured it out.

If you ever need to do this again, here are a couple of methods that can be used with Glide Tables:

How do I create an auto-incrementing row number with Glide Tables?

This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

@Majestic_Intern

Collecting the form responses from Mighty Forms because it will be embedded on a website. I will not be using a user-facing application, just a back-end application.

Also making a long line item (in this case 29 columns) on glide can get a little tedious lol. Also I’m using conditional logic on the form input, which would force me to make a custom form and entry field placeholders on glide.

Fair enough

[Majestic_Intern]

Thanks for everything!