Can the info in the field of a non related record in another table be shown in a field?

  • 0
  • 1
  • Question
  • Updated 3 weeks ago
  • In Progress
  • (Edited)
I have a table that holds information that an automation setup by someone else puts info into a record when it's created.  The records aren't related when this happens, it just pulls data initially into a Note field.  Is there a formula that can retrieve some other info I need from another field?  I would use an If statement to let it know which info to pull, but I'm wondering if there is a formula to tell it which record and field to get the info from.

In other words, a formula that says, go to a specific field in a specific record in a specific table  and display the content.

The tables do have a relationship, but the records aren't related when the automation already in place creates the record.  Hope that makes sense.

Thanks,

Dana
Photo of Dana Hauser

Dana Hauser

  • 220 Points 100 badge 2x thumb

Posted 3 weeks ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
I suggest trying a Report Link field Type.  That Field type can run a report which will be filtered based on how you configure the two fields on the settings for that field.  Then you put that Report Link on the form and set the form properties to show the records on the form.  You do not need a Relationship.
Photo of Dana Hauser

Dana Hauser

  • 220 Points 100 badge 2x thumb
Thanks, that's very helpful.