Best Practice for creating a single value Role Column?

[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