Skip to main content
Question

Table-to-Table: Add All Formula?

  • May 28, 2024
  • 0 replies
  • 144 views
MeaganMcOlin
Forum|alt.badge.img+7

I have a table-to-table app with three tables: Employees, Access Groups, and Permissions. The Permissions table is used to link the other two tables. Each Access Group has multiple Employees, and each Employee has multiple Access Groups.
However, I need one Access Group that includes all Employees. Is there a way to add all without selecting and saving individually for 500+ employees?

Thank you!
Meagan

This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

You can make an excel file and import it.

Mark Shnier. Your Quickbase Coach
MarkShnierYou
Forum|alt.badge.img+24

Right so you want to create 500 new records in the access group join Table. That middle join Table probably only has two fields. It has a field for related employee and a field for the related access group. So just export the entire employee table into excel, but you only need to export the key of the table which is probably just the Record ID field. 

 

Look at the record ID in Permissions, which seems to be the list of your various groups and find the record ID for that permission group that needs to have all employees added. Let's say it's record ID 123.

 

Then just go into Excel and run that 123 number all the way down with the column B of your spreadsheet 

 

Then import those two columns into the middle table, which is  access groups. 

Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement