Using form Variables in Custom Spreadsheet Formulas?

[Darren_Murphy]

@Rcart

However, I encountered a small issue where the application creates two rows in my spreadsheet when I submit the form. Do you have any suggestions on how to ensure it only creates one row?

That’s because you have an onSubmit action that Adds a Row.
So when your form is submitted, a row is added. And then your onSubmit action adds a second row.
You need to get rid of that onSubmit action.

I’d also encourage you to have a closer look at what @ThinhDinh said earlier…

@ThinhDinh

That sounds like a use case for a combination of relation & lookup.

In your destination table, create a relation linking the client code with the right column in the Client table. Don’t click the “match multiple” box.

The above is a much better approach than messing around with GSheet formulas. As a general rule, you don’t need any GSheet formulas when working with Glide (except in very rare cases). The Glide Data Editor has all the capability that you’re ever likely to need, and your App will perform much better if you avoid GSheet formulas.

Trash your Excel Formulas

Hey Gliders! By request, I created a video that explains how to replace 14 commonly used Google Sheet/Excel Formulas using Glide computed columns and other native Glide functionality. Formulas are timestamped in the description. For good measure, I also threw in how to use the Excel Formula plugin column Enjoy! [Glide: Replace 14 Excel Formulas with Glide Computed Columns]