Skip to main content
Question

Show a numeric field from a different table without creating a releationship

  • April 6, 2017
  • 0 replies
  • 37 views
Hi Team,

I have a scenario where I have to show a numeric field without creating a relationship.

I have done the same thing for showing an attachment like this and it's working fine:

If([Country]="A",  "<a href="&URLRoot() & "up/" & [_DBID_TEST] & "/a/r100/e8/v0"&">Test 1 Link</a>",  If([Country]="B",  "<a href="&URLRoot() & "up/" & [_DBID_TEST] & "/a/r42/e8/v0"&">Test 2 Link</a>",  If([Country]="C",  "<a href="&URLRoot() & "up/" & [_DBID_TEST] & "/a/r28/e8/v0"&">Test 3 Link</a>",  If([Country]="D",  <a href="&URLRoot() & "up/" & [_DBID_TEST] & "/a/r36/e8/v0"&">Test 4 Link</a>"  ))))

Any workaround for this?

Thanks in advance.

Regards,
Gaurav Sharma

      • MCFNeil
      • Quickbase Alumni
      • April 6, 2017
      Without a relationship you will either need to push a button to do a query of the other table, or use a version of the IOL and script to automatically query those records and display the result.

      Any reason why you want to avoid the relationship?

      The "link" example you used above is because it is pulling a formulated URL, and not a value.
      Terms & ConditionsAccessibility statement