Adding and viewing data > Entering data in records > Copying and moving data in records
 

Copying and moving data in records

 

To

Do this in Browse mode

Copy or move a value from one field to another

Select the contents of the field, then choose Edit menu > Copy or Cut. Display another record, if needed. Click the field to hold the data, then choose Edit menu > Paste.

Copy a value from a field in the last record that you accessed

Click the field that you want to hold the data, then choose Insert menu > From Last Visited Record.

Copy values in a record to another application

With no field selected, choose Edit menu > Copy. In the other application, paste the record that's on the Clipboard.

Copy all data in a record (including any related records in a portal and fields on tab panels or slide panels that are on the frontmost panel)

With no fields selected, choose Edit menu > Copy.

Note  Fields are not copied if they are:

on tab panels or slide panels that are not on the frontmost panel

on closed popovers

in portals that display records from the current table

Copy all records in the found set to the Clipboard (but not data from tab panels or slide panels that are not in front)

With no fields selected, press Shift (Windows) or Option (macOS) while choosing Edit menu > Copy.

Paste text from the Clipboard without formatting (like bold or italic)

Click the field you want to hold the text, then choose Edit menu > Paste Text Only.

Paste text from the Clipboard with formatting (like bold or italic)

Click the field you want to hold the text, then choose Edit menu > Paste.

Notes 

When you copy a record, everything is copied except data in container fields. Data is copied in tab-delimited format, in the order the fields appear on the layout.

You can copy and paste the contents of individual cells in Table View. You can't copy and paste the contents of multiple cells, but you can copy the current record or found set to the Clipboard.

Related topics 

Saving and copying files

Moving through records

Finding records