Skip to main content
Question

Show field value from specific record

  • February 6, 2020
  • 0 replies
  • 35 views
Hi,

Is there a way to show the field value for a specific record ID on another table using a formula field? 

The tables are related, but it's not a related record.  It's a specific record on another table.  I don't want to put the info statically, I want it dynamic in case the value in the record changes.  It's an email address for a specific person in a specific role.  If this person changes, the new person would have a different email address, which would be updated in the record.

Thanks,
Dana


------------------------------
Dana Hauser
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • February 6, 2020
np,
I will assume that this Parent table has a Key field of the usual Record ID#. 

Make another relationship where say 1 staff member has many  detail records.  Let the system create a field for you and initially it may be called like [Related Staff Member 2].

edit that field's properties and change the name to be 
[Record ID# of a specific person in a specific role] // think of a better name

Change the field type to be a formula numeric.

Look at the Staff member table and see what the Record ID is for this special person.  say its 123

Make the formula for that field be

123

Then lookup whatever details you need from that Staff member record down to your detail records.

If Ms. 123 ever changes as the special person, then just edit that formula field to be the new special person's Record ID.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+15
  • DonLarson
  • Quickbase Alumni
  • February 6, 2020
Dana,

Your business case is missing and that might really impact the solution.

Lets assume you have Projects and Project Managers.   You want all Projects to know the email address of the Project Manager where the Record ID# is 100

Create a Formula Numeric field Related Master Project Manager in Projects and set the value to 100
Now every Project has that as a value of 100

Now create a second relationship between Project Manager and Projects
Make sure you pick Related Master Project Manager as the Reference Field.  Do NOT let it create Related Project Manager. 

Here is your ERD


That will get the Master Email into every Project.  When you edit Record ID# 100 every Project will change.

This might not support the rest of your business case for work flow and reporting but gets the data there.



------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Terms & ConditionsAccessibility statement