Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Combining multiple records into a single field

Topic Labels: Scripting extentions
1700 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Grace_Canon
4 - Data Explorer
4 - Data Explorer

Really new to scripting and I feel like this should be possible but I’m not sure how to manage it.
When I copy and paste the information from my source (a website) into my table, it obviously only fills up the first column (“Name”) with not only the names, but all of the copied info into individual rows.
What I would like to do, is create a script or automation to cut and paste the information between the actual names into the second column (called “Notes”) which is where I have automations to pull from that content and auto populates info into the corresponding fields.

Here is my attempt to visually show what I am trying to accomplish.

table

To be clear on how the data is pasted on the table, just before the actual name (which is unique) there is always the same field type. It begins with “Date” and ends correspondingly.
I want to collect all of the text in the fields between each actual name, and paste it into the “notes” field of the name that it belongs to (just above it.) Eventually I would need to delete the fields that I’ve copied, but I know that’s a step I can manage automating on my own.

I’m open to ideas on how to make this process easier! In my current project there are over 450 records I’m trying to get to, with 4,000+ currently. While I could (tediously) do this one at a time, this isn’t my first project like this and I need to create a timely automated workflow.

I have looked into different ways to paste the data into another program first to try and create columns that would be easier to import, but haven’t had any luck. Thanks in advance for any help you have!

2 Replies 2
Eduardo_Pimente
6 - Interface Innovator
6 - Interface Innovator

Hi!
I’m having some fun for the last couple of days learning on scripting… I’d like to try to help on this, let’s see if I can. :winking_face:

But being colorblind didn’t help understanding your explanation with colored dashes and dots :grinning_face_with_smiling_eyes:

Would you mind filling the table by typing some aleatory information as example besides the explanation you gave?

Thanks!

Thank you so much!!!

Also, to note, in the comment I made about how the data is pasted into the table… I don’t know why I said “Dates”. I meant to say “notes” is always the row before the title.

I hope this illustration is easier to understand! Thanks again!
image