Jump to content
Sign in to follow this  
Myrtle

Moving data from portal to new table

Recommended Posts

I have a portal in one table showing address information. I would like to click on the record in the portal and then click on a button that would be scripted to take that information and put it into the correct field of a current record in another table.

Can anyone help me with this? I am not sure what that script would look like.

Share this post


Link to post
Share on other sites

It could be as easy as this (in pseudo code):(

Save the contents of each field in the portal to a script variable.

Go to the other table.

Put the contents of each variable into the fields of the current record.

A hint for implementation: have the button that runs this script *in the portal row itself* not outside the portal. If the button is outside the portal, the moment it's clicked the focus is moved from the portal to the button, and there is no way to know which portal row was previously selected.

Share this post


Link to post
Share on other sites

Putting the button in the portal works very well, but I'm not sure I've figured out how to save the field information as a script variable. I can manage pasting the entire record, just not one field.

Thank you for your explanation. I really appreciate your advice.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.