Skip to main content
Solved

Pasting into linked field will not create new rows in linked table

  • February 16, 2024
  • 3 replies
  • 33 views

Forum|alt.badge.img+3
  • New Participant
  • 1 reply

I'm pasting a single-line text field ("Whisky Name") into a linked field ("Link to Summary Page"), and it used to paste all the names across into the linked field. The action was that if a name matched with an existing one, it linked it to the existing one and if it didn't, it created a new line in the summary table.

When I pasted all the single-line texts across, it matched the existing ones and left all the ones that would be 'new' items blank. I know this because if I manually select the link cell, type in the name (nothing shows up), and 'click create a new record' it works. In that case, if I have a duplicate further down and I try the copy-and-paste method, it works because it now has a match.

Has something changed?

Best answer by Renatto_Andrade

Yes, the primary field of the linked table was a formula field.

I converted it to the auto number field and tried again, and still no luck.


If you change the primary field of your linked table to be a single line text type, then this should work no problem. Really any editable type for the primary field will work, provided you're pasting in correctly formatted data. Formula and Autonumber types won't work for this.

3 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Just tested this and it creates records fine for me.  Is the primary field of your linked table a formula field?  That will prevent new records from being created with this method


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 1 reply
  • February 16, 2024

Yes, the primary field of the linked table was a formula field.

I converted it to the auto number field and tried again, and still no luck.


Renatto_Andrade
Forum|alt.badge.img+9
  • New Participant
  • 1 reply
  • Answer
  • February 16, 2024

Yes, the primary field of the linked table was a formula field.

I converted it to the auto number field and tried again, and still no luck.


If you change the primary field of your linked table to be a single line text type, then this should work no problem. Really any editable type for the primary field will work, provided you're pasting in correctly formatted data. Formula and Autonumber types won't work for this.