Test for Zappier / Chris Ryan

Senior Art Editor at Nature News in London.

Public

Edited

Jul 31, 2023

draftText = "https://drive.google.com/open?id=1DHfgmq1ldj5Qg53EiRNzTOkrx2_k26Cb, https://drive.google.com/open?id=1UnPClZGHQ5Y3d9iFsnys0Rvv5x_6gL_S"

draftText2.split(",").map((d) => d.trim())

draftText2 = "https://drive.google.com/open?id=1DHfgmq1ldj5Qg53EiRNzTOkrx2_k26Cb"

data = FileAttachment(

"Copy of Nature Art briefing form (Responses) - Form Responses 1.csv"

).csv()

formatBasecampMessage = (d) => {

const trelloTitle = d["Please paste your Trello article title here"];

const headline = d["Working headline"];

const standfirst = d["Working standfirst"];

const editor = d["Editor name"];

const date = d["Issue date print"];

const synopsis = d["Synopsis"];

const draftText = d["Draft text"];

const additionalInfo = d["Please add any additional information here"];

const photography = "Yes";

const photographyDetails = d["Photography"];

const photographyLinks =

d["Please upload image suggestions, ideas or any other relevant material."];

const illustration = "Yes";

const illustrationDetails = d["Illustration"];

const illustrationLinks =

"Please upload illustration suggestions, ideas or any other relevant material."

];

const infographic = "Yes";

const infographicDetails = d["Infographic"];

const infographicLinks =

d["Please upload data or relevant attachments for each graphic."];

const immersive = d["Online immersive presentation"];

const immersiveDetails = d["Please add any additional information"];

let mainMessage = `Working headline: ${headline}

Working standfirst: ${standfirst}

Editor: ${editor}

Issue: ${date}

Synopsis: ${synopsis}

Additional information: ${additionalInfo}

${formatGoogleDriveLinks("Draft text:", draftText)}

let photoMessage = "";

if (photography === "Yes") {

photoMessage = `Photography:

${photographyDetails}

${formatGoogleDriveLinks("Reference images:", photographyLinks)}

}

let illustrationMessage = "";

if (illustration === "Yes") {

illustrationMessage = `Illustration:

${illustrationDetails}

${formatGoogleDriveLinks("Reference images:", illustrationLinks)}

}

let infographicMessage = "";

if (infographic === "Yes") {

infographicMessage = `Infographic:

${infographicDetails}

${formatGoogleDriveLinks("Reference:", infographicLinks)}

}

let immersiveMessage = "";

if (immersive === "Yes") {

immersiveMessage = `Immersive/Shorthand presentation:

${immersiveDetails}

}

return `${mainMessage}${photoMessage}${illustrationMessage}${infographicMessage}${immersiveMessage}`;

}

formatBasecampMessage(data[0])

formatGoogleDriveLinks = (title, d) => {

let result = "";

if (!title.length && !d.length) return result;

const linksArray = d.split(",").map((d) => d.trim());

if (linksArray.length && linksArray[0].length) {

const formattedString = linksArray.reduce((accumulator, currentValue) => {

const newValue = (accumulator += `• ${currentValue} \n`);

return newValue;

}, "");

result = `${title}\n${formattedString}`;

}

return result;

}

formatGoogleDriveLinks("Title:", draftText)

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.

Learn more