How to Clean Up Your Data Transfers with One Simple Zapier Code Step

The Problem: Messy Data Transfers

First Name: John
Last Name:
Email:
Date: 2024-03-15
Question 1:
Question 2: Yes, I'm interested

The Solution: One Simple Zapier Code Step

1. Set up your Zap with your trigger (e.g., a new form submission) and your action (e.g., creating a Google Doc).

2. Add a "Code by Zapier" step between your trigger and action.

3. Choose "Run JavaScript" as the action event.

4. In the "Input Data" section, map all the fields from your trigger step.

5. Copy and paste the following code into the "Code" section:

let firstName = inputData.firstName ? `First name: ${inputData.firstName}` : null
let lastName = inputData.lastName ? `Last name: ${inputData.lastName}` : null
let email = inputData.email ? `Email: ${inputData.email}` : null
let date = inputData.date ? `Date: ${inputData.date}` : null
let question1 = inputData.question1 ? `Question 1: ${inputData.question1}` : null
let question2 = inputData.question2 ? `Question 2: ${inputData.question2}` : null

let final_string = ""

if(firstName) {
  final_string += firstName + "<br>"; 
}

if(lastName) {
  final_string += lastName + "<br>"; 
}

if(email) {
  final_string += email + "<br>"; 
}

if(date) {
  final_string += date + "<br>"; 
}

if(question1) {
  final_string += question1 + "<br>"; 
}

if(question2) {
  final_string += question2 + "<br>"; 
}

output = [{final_string: final_string}];

1. In your final step (e.g., creating a Google Doc), use the output from the Code step instead of mapping individual fields.

How It Works

1. It defines a final_string value that takes a label and a value. If the value exists, it creates a string with the label and value. If not, it returns an empty string.

2. It then builds the output string by calling this function for each field.

3. Only fields with actual values will be included in the final output.

The Result

First Name: John
Date: 2024-03-15
Question 2: Yes, I'm interested

Customizing the Code

• Add or remove fields by adding or deleting lines in the output construction.

• Change the formatting by modifying the final_string function.

• Add additional logic or transformations as needed.

Conclusion

Need support setting this up? We can help!