Google Sheet - Update a empty row at a specific line (ERROR)

[DanytheRogg]

Hi together

Here’s my problem description:

I have a Google Drive sheet with multiple rows and columns. The rows contain emails, and the columns have month 2, month 3, and month 6 as column headings in the first row, starting from columns L to P.

I receive an email address via a webhook. First, I use the “Search Rows” module to search for the row containing the email address. This works. For example, I get row 17 because that’s exactly where the email address is.

Next, I want to enter a “✓” in one of the columns from L to P in the row containing the email address found (in my example, it’s row 17). I simply want to use the next free column from the list. If columns L and M already contain a “✓,” column N is used, and the “✓” is entered there.

Hier ist the scenario from search rows:

“Search Rows” also works, I have used it elsewhere

Now the “Set variable”. I want to set the variable “freecolumne”. The empty column between L and P should be determined. For example, an M stands for column M in the variable “freecolumne”

Next, I use the “Update a Row” module. Here, I want to pass the variable “freecolumne,” which is the next empty column in the row determined by “Search Rows.”

From here on, nothing works.
I enter the row number in the correct place and then, at the very bottom, activate the slider for “Map” and “Show advanced settings.”
For the “Value input option,” I then enter, for example, the following:
{{if(19.freecolumne + " =L"; “✓”; )}}. I’ve already tried various other variants, including entering the columns themselves further above, even with an if statement, but nothing worked; I always get the same error.

Hier noch ein Screenshot:

How can I solve this easily, without using a lot of modules/operators and simply?

Thank you soooo much

[samliew]

Welcome to the Make community!

I think you are using the equals character incorrectly - it should be an operator, not typed as a string. Try to click on the equals sign in the variables panel.

Also, the parameters of your if function is not valid. How does your spreadsheet look?

You have not yet provided sufficient information to demonstrate the problem that would allow us to reproduce the scenario and any error(s).

To allow others to assist you with your scenario, please provide the following:

1. Relevant Screenshots

Could you please share screenshots of your full scenario? Also include screenshots of any error messages, module settings (fields), relevant filter settings (conditions), and module output bundles. We need to see what you’re working with to give you the best advice.

You can upload images here using the Upload icon in the text editor:

2. Scenario Blueprint

Please export the scenario blueprint. Providing your scenario blueprint file will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return - this would greatly benefit you in implementing our suggestions as you can simply paste module exports back into your scenario editor!

To export your scenario blueprint, click the three dots at the bottom of the editor then choose ‘Export Blueprint’.

You can upload the file here by clicking on this button:

3. Output Bundles of Modules

Please provide the output bundles of each of the relevant modules by running the scenario (you can also get this without re-running your scenario from the History tab).

Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

• Method 1: Type code block manually

  Add three backticks ``` before and after the content/bundle, like this:

  ```
  <sup>content goes here</sup>
  ```

• Method 2. Highlight and click the format button in the editor

  

Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved.

Sharing these details will make it easier for others to assist you.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[DanytheRogg]

Thanks but as new member I cant upload more then 3 Screenshots.

Now all works, but even one thing doesnt work:

I have a specific row which I found with “Search Rows”. This works fine. Now I want in this specific Row the next free column between column g to k. Only columns G through K should be considered. A “true” should be entered into the next free column (between column G and K).

I hope that is possible?