I am trying to use a formula field to create a dynamic, conditional link. I want to check to see if an organization has any members and if so display the organization name as a hyperlink in a view that links to a summary page for that organization. If there are no members in an organization, the organization name should appear as simple text (no link).
I can get each step of this process to work individually but putting it together doesn't seem to work. Am I doing something wrong or is this just not possible? (I can get this entire process to work using regular Deluge script but this does not have the same "on-the-fly" functionality as a formula).
I can make the organization name field appear as a link unconditionally using this formula:
"<a target='_parent' href='https://creator.zoho.com/licehappens/lice-happens-v1-1/#View:Open_Dash_Professional_Org?ID=" + ID + "'>" + Organization_Name + "</a>"
I can make a conditional formula which correctly determines whether an organization has members using:
if count(Professional[OrganizationFKID == ID] >0), input.Organization_Name,input.NoMembers)
However, if I try to do something like this:
if count(Professional[OrganizationFKID == ID] >0), "<a target='_parent' href='https://creator.zoho.com/licehappens/lice-happens-v1-1/#View:Open_Dash_Professional_Org?ID=" + ID + "'>" + Organization_Name + "</a>", input.Organization_Name), the formula won't save. Storing the link string in another field and recreating the formula like this: if count(Professional[OrganizationFKID == ID] >0), input.Linkstring, input.Organization_Name) does not work either.
It would be great if this could work! Thanks in advance for your help!
John