I have been getting inconsistent results when inputting data in a linked record field. When I paste a comma separated list into the field, I randomly get one of the following results:
I have performed the paste action several times in a row and gotten different results. Can anyone explain why? Has anyone else had this?
Scenario 1 is the result I am expecting.
Thank you!!
+18Hi @Paul_Warren,
You should be getting Scenario 1 in that when you paste it, it will create a new linked record only if there isn’t one already there and if that record already exists, it will link to it. This is true even if the table is filtered.
The only way that I was able to replicate Scenario 2 was by using another symbol such as the other commonly used semicolon. Can you provide a sample text that is causing you to get Scenario 2?
I get this same result using the following two lists:
List1: 3.23, 3.24, 3.25, 3.26, 3.27, 3.28, 3.29, 3.30, 3.31, 3.32
List2: 10462, 10465, 10466, 10467, 10468, 10471
Also, both of these lists are from copying a similar linked record field (linking to the same records in the same table) on a view-only link. However, copying from the collaborator view doesn’t seem to change the result.
I believe I have fixed the issue by making the First column of the Linked table a formula. Now it seems less likely to think I want to create a new record with a text input. Still, it seems strange to get such inconsistency in the first place.
+18I get this same result using the following two lists:
List1: 3.23, 3.24, 3.25, 3.26, 3.27, 3.28, 3.29, 3.30, 3.31, 3.32
List2: 10462, 10465, 10466, 10467, 10468, 10471
Also, both of these lists are from copying a similar linked record field (linking to the same records in the same table) on a view-only link. However, copying from the collaborator view doesn’t seem to change the result.
I believe I have fixed the issue by making the First column of the Linked table a formula. Now it seems less likely to think I want to create a new record with a text input. Still, it seems strange to get such inconsistency in the first place.
Aww, I wonder if it has something to do with a hidden html element? I’m not an expert in this area.
Sorry that I couldn’t be of more help.
Aww, I wonder if it has something to do with a hidden html element? I’m not an expert in this area.
Sorry that I couldn’t be of more help.
Thanks for your input! That is very possible.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
