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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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