Forum Discussion
Column Default Value Based on Root URL
Ashish_Kohale thank you very much for your super fast reply and sorry for mine being sooo late; I'd rolled out the ad hoc sign up system I had and got entangled in maintaining it daily. Now that I have some more time, I am going back to this to see if I can figure it out.
1) Yes, the root URL is fixed. It is saved as an event on SharePoint site, so that is clear.
2) You are saying that I should create another list with the URL of each event and its corresponding name, yes? So far so good. But then you are suggesting that in the event sign up list, the default value of the event name is a formula that takes the root URL and matches it with the URL-name list and returns the corresponding event name in that list?
I get the logic and it sounds like the solution to my problem. But I am not sure how to:
a) the function to take the root URL
b) the function to look up this source URL in another list on the same site and match the name
Can you please help me with these functions? Better even, can you please give me a hint of how the formula would look like in the default value field?
Again, thanks a lot and sorry for your help the late response.
beshr1993 : I think you can user REST api to get the data from another list and check the values on success of rest function, hope it helps.
Ashish_Kohale Thank you for the suggestion. I will look into it, but first I must learn a bit of REST api because, I must admit, I know next to nothing about it 😅