Column Default Value Based on Root URL
I have a tab in an MS Teams team where users can view our upcoming corporate training sessions (i.e. Events). In each event description, I am putting a link to a sign up form. The sign up form is a list in MS SharePoint Online. In this list, there is a column to specify the event to which the user wants to sign up. I want this column to be automatically filled using the column default value function in SharePoint. The default value would be based on the root URL that led the user to the sign up form. For example, if the user was viewing training session X in Teams, it means the root URL is the event X URL. So, the formula would be: IF [Root URL] = (URL of event X) then "X", ELSEIF [Root URL] = (URL of event Y) then "Y"... and so on. Does this hypothetical [Root URL] function even exist? If not do you have any suggestion for how I can tell which event the user is coming from such that I can fill the column automatically? Thanks.
