I'm trying to pass through information from a gravity form submission on a Woocommerce order for use in another app using Zapier. I need to split the form entry information so that the information is not all on a single line and can be individually accessed.
As I'm quite new to JavaScript, I have been struggling for hours trying to get this to work... The code I am using is from the woocommerce documentation. The problem is that a chunk of information can be cut off if said information continues onto a new line. Please see the result of the split below and refer to Question 2 to see what I am talking about.
Code:
// Define "metaData" in the Input Data section. Ignore the "No Data" label.
// Reformat Resource Meta Data to generate keyvalue pairs.
// In case of multiple equal keys, only the last value available.
const buffer = {};
const metaData = inputData.metaData.split(/\n+/);
metaData.forEach((dataString, index) => {
if (dataString.includes('id:')) {
const key = metaData[index + 1].replace('key:', '').trim();
const value = metaData[index + 2].replace('value:', '').trim();
buffer[key] = value;
}
});
return buffer;
An example form submission would like like this:
Name: John
Last Name: Doe
Email: john.doe@gmail.com
Question 1: this is my first question
Question 2: hi there,
this is my second question..
regards, john doe
Question 3: This is my third question
What the result of the split looks like:
Name: John
Last Name: Doe
Email: john.doe@gmail.com
Question 1: this is my first question
Question 2: hi there,
Question 3: This is my third question
As you can see, Question 2 basically missing.. I have been unable to figure out a way to get this working. I hope that someone is able to lend me a hand here...
EDIT: __________________
RAW as requested:
id: 419*** key: _gravity_forms_history value: {'_gravity_form_cart_item_key': '************************************', '_gravity_form_linked_entry_id': ****, '_gravity_form_lead': {'2': 'This is my first question', '6': 'john.doe@gmail.com', '7': '2020-08-01', '8': 'hi there,\r\nthis is my second question..\r\n\r\nregards, john doe', '9': 'This is my third question', '11': 0, '12': this is a random form entry', 'form_id': '3', 'source_url': 'https://***************************/', 'ip': ***************', '5.2': '', '5.3': 'John', '5.4': '', '5.6': 'Doe', '5.8': '', '10.1': 'Product Name', '10.2': '$0.00', '10.3': '1'}, '_gravity_form_data': {'id': '3', 'bulk_id': 0, 'display_title': False, 'display_description': False, 'disable_woocommerce_price': 'no', 'price_before': '', 'price_after': '', 'disable_calculations': 'yes', 'disable_label_subtotal': 'yes', 'disable_label_options': 'yes', 'disable_label_total': 'yes', 'disable_anchor': 'no', 'label_subtotal': 'Subtotal', 'label_options': 'Options', 'label_total': 'Total', 'use_ajax': 'no', 'enable_cart_edit': 'no', 'enable_cart_edit_remove': 'yes', 'keep_cart_entries': 'no', 'send_notifications': 'no', 'enable_cart_quantity_management': 'no', 'cart_quantity_field': '', 'update_payment_details': 'no', 'display_totals_location': 'after', 'structured_data_override': 'no', 'structured_data_low_price': '', 'structured_data_high_price': '', 'structured_data_override_type': 'append'}}
id: 419***
key: Name
value: John Doe
id: 419***
key: Email
value: john.doe@gmail.com
id: 419***
key: Date of Birth
value: 01.08.2020
id: 419***
key: Question 1
value: This is my first question
id: 419***
key: Question 2
value: hi there,
this is my second question..
regards, john doe
id: 419***
key: Question 3
value: This is my third question
id: 419***
key: Final Entry (Optional)
value: this is a random form entry
Expected result as requested:
Name: John Doe
Email: john.doe@gmail.com
Date of Birth: 01.08.2020
Question 1: This is my first question
Question 2 :Hi There,
This Is My Second Question..
Regards, John Doe
Question 3: This is my third question
Final Entry: this is a random form entry
id: ******************************
runtime_meta:
memory_used_mb: 72
duration_ms: 100
logs:
async: false
Current result as requested:
Name: John Doe
Email: john.doe@gmail.com
Date of Birth: 01.08.2020
Question 1: This is my first question
Question 2 :Hi There,
Question 3: This is my third question
Final Entry: this is a random form entry
id: ******************************
runtime_meta:
memory_used_mb: 72
duration_ms: 100
logs:
async: false
What the result of the split looks like:
Name: John Last Name: Doe Email: john.doe@gmail.com Question 1: this is my first question Question 2: hi there, Question 3: This is my third question
No, no, no, no, no. This is what you think the result of splitting is. You have a bug in your code and you have chosen to believe that the split function is at fault rather than your code.
In your forEach loop, add a line such as
console.log('XXXX', dataString);
immediately above the line if (dataString.includes('id:')) {. You will see every line of your input logged out with the XXXX prefix, including those you claim to be missing.
So why is your code not doing what you want? Well, let's take a look at the contents of the function called by forEach:
if (dataString.includes('id:')) {
const key = metaData[index + 1].replace('key:', '').trim();
const value = metaData[index + 2].replace('value:', '').trim();
buffer[key] = value;
}
What does it do? If one line of a file contains id:, take the key and value from the next line and the line after that. If a line of a file doesn't contain id:, don't do anything with it.
In your case, question 2 contains more than one line, which, as we can see, your code completely ignores.
If, instead of just reading the line-after-next into the value, you want to read all lines up to but not including the next line with id: in it, try the following:
if (dataString.includes('id:')) {
const key = metaData[index + 1].replace('key:', '').trim();
let value = metaData[index + 2].replace('value:', '').trim();
let index2 = index + 3;
while (index2 < metaData.length && !metaData[index2].includes('id:')) {
value += "\n" + metaData[index2].trim();
index2 += 1;
}
buffer[key] = value.trim();
}