I have created an App column to conditionally link to a form or a row. Example:
IF([1 Key] <> "#", LINKTOROW([1 Key], "Lab Inspection_Detail"), LINKTOFORM("Lab Inspection_Form", "Lab", [Lab ID], "Lab Inspection Category", "2d8f09a7") )
In this case, when the [1 Key] column is #, I link to the form. When [1 Key] column is not #, I link to the a detail view of Lab Inspection_Detail.
However, there are some cases where I don’t want to LINKTOROW and I don’t want to LINKTOFORM. I just want it to do nothing.
Is there something I can use in these cases? Such as NULL or # or something?