Writing HTML to Google Sheet instead of value
-
Greetings,
Thank you for this plugin. I have it configured to populate a Google Sheet with certain form field values that are derived from calculations. It’s populating but instead of writing just the calculated value to the Google Sheet, it’s writing the HTML to the sheet instead.
For example, where we just want the value “8.00” to appear in the Google Sheet cell, it is writing the following:
<p>Total Work Hours: <span data-key=”calc:Total_Work_Hours”>8.00</span><span id=”nf-drawer-content”><span class=”nf-setting-groups”><span class=”nf-field-settings”></span></span></span><br></p>
How do I format either the Google Sheet or the Ninja Form to only display the value and not the surrounding HTML?
Here is how the HTML field with the calculation is constructed in Ninja Forms:
https://snipboard.io/8TpjvX.jpg
The calculation works because it is being output onto the page where the form is when the form is filled out.
Here is what is being written to the Google Sheet:
https://snipboard.io/FKXsTb.jpg
Thank you for any help you can provide. I don’t use Google Sheets very often so it may be some simple setting that I am unaware of.
The page I need help with: [log in to see the link]
The topic ‘Writing HTML to Google Sheet instead of value’ is closed to new replies.