1:N Relationship Error occurred when adding a second row on a Budibase DB table with auto column "Updated By" type

[masumo]

Checklist

• I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker single image
  • Budibase Version: 3.4.5
  • App Version: 3.4.5

Describe the bug
When creating a second record in a Budibase DB table containing the auto column "Updated By", the following error occurs: "1:N Relationship Error: Record already linked to another."
Removing the auto column resolves the issue.
This behavior was also observed on the Budibase cloud version.

To Reproduce
Steps to reproduce the behavior:

1. create table investor using Budibase DB with columns:

• id (Auto column: Auto ID)
• name (text)
• country (text)
• user (Auto column: Updated By)

2. create a first record of investor table with any data
3. create another (second) record with any data
4. 1:N Relationship Error error occurred and we can't save the second row data

Expected behavior
User able to create unlimited rows on a table with auto column "Updated By" type.

Screenshots

App Export
My first app-export-1739261227907.tar.gz

Desktop (please complete the following information):

• OS: MacOS 15.3
• Browser chrome
• Version 133.0.6943.54

[linear]

BUDI-9045 1:N Relationship Error occurred when adding a second row on a Budibase DB table with auto column "Updated By" type

[mikesealey]

I've been looking into this to find the simplest recreation for ease when solving this bug

In a new app...
Data

• create a table "things" with a columns "items" (Text) and "updated by" (Auto Column => Updated By)
  *Add a handful of rows into "things"

Design

• Add a table to the screen and set it to display "things"
• Publish

Published App

• edit a row and see your user email populate in the "updated by" column
• Edit another row to see the issue

Jam

App export: Users 1 to Many-export-1739366309820.tar.gz