Can you use a formula field to choose which related parent table to use?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have one main table: Calls. And 3 other tables: Names A, Names B, Names C.

In Calls I have a field named "Name" which takes a text input. Based on this input I would like to fill in a field named "Category" with which table it came from.

I currently have 'Category' set as a Formula - Text field with the following formula:

If([Name]=[Names A - Name], "Names A", If([Name]=[Names B - Name],"Names B", If([Name]=[Names C - Name], "Names C", "Unknown")))

Regardless of what I enter it always seems to comeback as "Unknown".

How do I make this work?

Photo of Joseph

Joseph

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
Can you give a bit of context behind the decision to have 3 Names tables?
Hey Joseph,

If you are still having issues with this, I would recommend submitting a support case to our Care team. You can submit a support case by logging into QuickBase, going to Help from any screen and selecting Manage Support Cases.