Get just the field name
I'm using GetFieldName () to enter a field name into another auto enter field. It returns Table::fieldname. I would like to just capture the fieldname alone withought the table name. How would I do this?
You can try:
If you'd want to know the name of the currently active field you can use Get ( ActiveFieldName ) that just returns the name
I ended up creating a little custom function
FieldNameOnly ( fieldname )
Let ([field = Substitute ( field ; "::" ; "¶" );tablename = GetValue ( field ; 1 )fieldname = GetValue ( field ; 2 )
Since my goal is to make sure this remains valid even if I change the field name I call it using GetFieldName ().
FieldNameOnly ( GetFieldName ( Name ) )
Retrieving data ...