Hi @Jon Hall 

Check out this article for inspiration:

You may have to use a couple steps in your Zap to handle the logic you’ve described.

1. Find Row
2. Evaluate returned data
3. Update Row

Hi,

Thanks for your help :)

I’ve got it to add the formulas fine.

And I’ve got it to calculate which is the cell the new data needs adding to (O1 in the example).

I can’t quite figure out how to add data to cell O1 specifically though.

I can get it to select row O (in this case) and update the columns I select in that ‘Update row’ step, but can only seem to pick from the rows it gives as opposed to referencing O1.

Apologies if I’ve not made that clear enough and, again, any help is greatly appreciated :)

Thanks,

Jon

Hi @Jon Hall 

Please provide screenshots to help clarify your current Zap step configurations.

I’ve done a loom video which, hopefully, shows what I’m trying to do more clearly → https://www.loom.com/share/5b0677741a3d49139faa12b55d8656cf

Hi @Jon Hall!

I’m sure there’s a more glamorous coding solution but here’s something that seems like it should work, and is pretty clever if I do say so myself 

We have something called Named Variables (read this recent article we wrote about it for more info) and if you combine that with a Lookup Table you can produce multiple mappable fields from one lookup:

So I envision that you would use the number as you’re doing now but instead of outputting the letter, you would output all of the fields with only one of them containing a value:

It’s a bit tedious but it should get you what you need. In order to produce all of the mappable fields to set up Excel you’d want to do something like this (make sure to add the space so that the field outputs nothing as opposed to not being a field at all)…

… map the fields…

… then go back to the Lookup Table and create it with all of the key/value pairs you need:

Then like magic you’ll get the value in the spot that you need it :)

(I’m not able to embed the animated gif for some reason, but you can check it out here: https://cdn.zappy.app/7afeb0ef1b8e2764a99245afe7d9f3d9.gif)

Hi,

Thanks for this - greatly appreciated :)

I’ve got it now so I have an output of (for example) S123

How would I have it do another step where it inserts a value into that specific cell?

I can only see how to update the row and then have one of the columns in that row selected, which would be the same for everything coming through that step of the zap.

Apologies if I’ve missed something.

Thanks again,

Jon

Hi,

I still haven’t figured out how (if it’s possible) to insert a value into that specific cell if anyone has any ideas?

Thanks,

Jon

Hi,

I rebuilt the excel sheet so everything was on independent rows which are then added to to get this to work in the end.

Thanks for all the help and suggestions :)

Jon