Jump to content

Interesting quirk for unrelated field reference in field definition


This topic is 3984 days old. Please don't post here. Open a new topic instead.

Recommended Posts

One apparent limitation of using ExSQL() in the separation model is that you can't use unrelated tables in a field definition. So you'd need to related all your tables to one another.

 

I just discovered that you can bypass that limitation simply by wrapping your statement in a Let() and declaring a variable that includes wrapping a field in the GetFieldName() function. 

 

 

So the expression:

Let(
field = unrelated::table ;
field
)

returns an error.

 

 

However,

Let(
gfn = GetFieldName ( unrelated::table ) ;
field = unrelated::table ;
field
)

does not.

 

It doesn't even have to be a field from an unrelated table!

 

Interesting and hopefully helpful.

  • Like 2
Link to comment
Share on other sites

Very good to know.  I haven't run into that yet.  I've mainly been using scripts that include ExecuteSQL, or Conditional Formatting.  

 

I'm sure it saved future-me from having to post a question.

Link to comment
Share on other sites

This topic is 3984 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.