Automating Static Data Copy from One Table to Another

Welcome to the community, Apollo Industries! :grinning_face_with_big_eyes:

Yup, that’s what it takes. Could you describe the steps in your zap and how you’ve configured the template for each one?

Step 1: Trigger on new record
Step 2: JavaScript (see below)
Step 3: Find records in scheduler table
Step 4: Create new records (temporarily I am redirecting these to a copy of the table).

Here is the JavaScript code I’m using

//this code is required to turn the string containing record IDs into
//an array of objects. Because the output is an array of objects the following
//steps will run for each record found.

if (inputData.csString == null) {
var listArray = ;
} else {
var listArray = inputData.csString.split(",");
}
var output = ;
var arrayNos = listArray.length;
var i=0;
do {
var thisItem = new String(listArray[i]);
var thisItemObj = {};
thisItemObj.record = thisItem;
output.push({thisItemObj});
i++;
}
while (i < arrayNos);

Is there a way to upload screenshots? I tried to drag-n-drop and it put the link there. When I go to save, it tells me I cannot upload pictures to the community.

Jason

New users are restricted from doing certain things, including uploading images and posting links. Those restrictions are automatically lifted once you’ve been active for a while.

I’ll likely have to defer to someone else to dive in deeper. I do use Zapier from time to time, but have never done anything in it with JavaScript, and my JavaScript is a bit rusty, so I’m not sure that I understand how that script ties in with the rest of the process.

My preferred integration tool a the moment is Integromat. Based on your description, this could probably be set up in Integromat in just a few minutes, no script needed. If you’re open to exploring that option, message me and I can walk you through it.

@Justin_Barrett

I’m interested in Integromat. I went ahead and signed up for an account. If you could message me, that would be great. I cannot figure out how to message you directly. I feel like a noob…probably because I am new to this forum.

Thank you in advance.

Jason

We’ve built a tool that allows you to automatically copy a value from one field and paste it into another.

@Moe, does your tool allow copying a value from a field in one table to a field in another table?

Oh I see. It doesn’t support copying to another table yet. We’ll add that feature!