CF7 & CF7 Google Sheets Connector plugin indirect cell reference issue
-
Hi, I’ve searched all over the place for something similar to this and have been unable to figure out my issue. I’m guessing it’s something with the CF7 Google Sheets Connector plugin and not with the Contact Form 7 plugin, but I’m taking a shot that someone may be able to help here as I’ve gotten no response on the CF7 Google Sheets Connector plugins’ support forum.
Here’s the issue quickly. I need to send a hidden formula to a cell in my google sheet.
When I send this:
[hidden payment-amount default:”=If(X12>0,(65+25*Y12),0)”]
it works fine and my cell is populated with the results of the formula.
The problem is that I need an indirect cell reference for the X12 and Y12 parts because I don’t want the value of X12 and Y12. I want the value of the cell in column X and Y for the current row.My research shows that this should work:
[hidden payment-amount default:”=If(indirect(“X” & row())>0,(65+25*indirect(“Y” & row())),0)”]
However, when I send a form with this as my hidden variable, the target cell is blank.
If I type the formula directly into a cell, it works, so I think the formula is ok, but something is causing it not to send to the cell or is messing with the formatting or something.If anyone has any suggestions on how to get these indirect references to send properly to my google sheet, that would be awesome!
Thanks in advance for your time!
- The topic ‘CF7 & CF7 Google Sheets Connector plugin indirect cell reference issue’ is closed to new replies.