Updating Single Select Fields From Updated Linked Records

I'm creating an online portal to display my tables to users. The online portal I'm using doesn't display linked records on the table so I've had to find a workaround by adding additional fields to display the text from the linked records. I want to be able to create/update linked records field and have it automatically create/update the single select field (which display properly in my portal and has color options). What is the best solution for this?

Here's my table setup:
USERS (LINK) = linked username records from Usernames table
Name (from USERS (LINK)): lookup field to display the username as text
USERS = single select field (this is how I want the usernames to be displayed)

What I want:
Whenever I update or create a record in USERS (LINK), I want it to automatically translate the updated or created record as a single select field without creating duplicates. Currently my single select field USERS is blank. I want it to automatically populate the names from USERS (LINK) and update accordingly if I ever update usernames or add entirely new usernames.

Thanks.

Page 1 / 1

If I'm understanding correctly, there's 2 tables. A user table and a transaction table where the USER singleselect field is.

You can put the single select field in the USER table instead, and look up the single select field in the transaction table. That way it is always up to date!

If I'm understanding correctly, there's 2 tables. A user table and a transaction table where the USER singleselect field is.

You can put the single select field in the USER table instead, and look up the single select field in the transaction table. That way it is always up to date!

Yes, I have a USERS table and a PRIMARY table that includes the linked field of users and all related data. The reason I included all those additional user fields is because they were attempts at trying to automate the creation and population of the Single Select Field. The only reason for going through this hassle is because Single Select Fields when displayed in my online portal are more visually distinct than just plain text. I hope this clarifies things!

USERS (TABLE 1)

NAMES

user1

user2

PRIMARY (TABLE 2)

TASKS	COMPLETION TIME	USERS (LINK)	USERS (SINGLE SELECT)
task1	duration1	user1	user1
task2	duration2	user2	user2

USERS (TABLE 1)

NAMES

user1

user2

PRIMARY (TABLE 2)

TASKS	COMPLETION TIME	USERS (LINK)	USERS (SINGLE SELECT)
task1	duration1	user1	user1
task2	duration2	user2	user2

What difficulties did you face creating an automation that'll paste the value of the linked field into the single select field? Not sure what the resulting colors would be so that might be a problem

Highly recommend trying Sally's suggestion about moving the select field to the User's table and using a lookup field first though

What difficulties did you face creating an automation that'll paste the value of the linked field into the single select field? Not sure what the resulting colors would be so that might be a problem

Highly recommend trying Sally's suggestion about moving the select field to the User's table and using a lookup field first though

So the tables would look something like this?

USERS (TABLE 1)

NAMES	USERS (SINGLE SELECT)
user1	user1
user2	user2

PRIMARY (TABLE 2)

TASKS	COMPLETION TIME	USERS (LOOKUP)
task1	duration1	user1
task2	duration2	user2

So the tables would look something like this?

USERS (TABLE 1)

NAMES	USERS (SINGLE SELECT)
user1	user1
user2	user2

PRIMARY (TABLE 2)

TASKS	COMPLETION TIME	USERS (LOOKUP)
task1	duration1	user1
task2	duration2	user2

Yeap

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded