Copying over multiple fields with 1 click?

[customfamily]

Hey guys!

So I'd like to set up a script that creates a new entry on a new layout and copies over several of the field from the previous layout. Ideal would be if after this it copied back the new entries ID number into the relating field of the original layout.

I KNOW that this may seem like a duplication of information which goes against some database rules but it's the way we need it to work.

I've gotten to a point but when it comes to copying my script always ends up pasting only the first copied field...I'm trying to copy several fields to several others, not many to one or one to many.

I've been trying a straightforward approach of using the copy script but I can't get it to copy several fields. Yes, I am a noob of sorts.

Thanks so much for any and all ideas.

Best,

Rob

[Lee Smith]

Repeating Fields?

[customfamily]

They're in separate tables if that answers your suggestion :

[T-Square]

Not knowing really what you're trying to do, you *could* set your script up so that it gets the source fields passed as a script parameter. You would then break the parameter up into the fields and paste the values in using set field script steps, one per field.

Another way would be to use lookups in the new table, based on relationships back to the original tables using the calling record's ID.

David

[customfamily]

Thanks, tried it and I think lookups are the way to go. Although I still would like to know whether there would be a solution to copy over an entry into a new table.

But thanks, works like a charm for now.

[Lee Smith]

T-Square gave you two ways that might help in this.

Read about the Set Field script step. Here

It might be time for you to attach an example of your file so that we can see what you are trying to do.

Lee