Cant edit now so clarifying:


I have a field with the project name. and I want to use that name in a URL to individualize the path.

So Field/Column 1 is field type NAME.


The contents for example


Record/Row 1 is fred


Record/Row 2 is barney

Field/Column 2 today is field type URL


Row 1 http://basepath/fred/index.html


Row 2 http://basepath/barney/index.html


But the difference is the same as the content of Field Column 1

What I want is FIeld/Column 2 (field type URL) and effectively auto look up the NAME


Row 1 http://basepath/{NAME}/commonpath (Fill using NAME for same row (1))


Row 2 http://basepath/{NAME}/commonpath (Fill using NAME for same row (2))

That way I can just copy the formula but all the URL links are the same initially but populate properly when displayed. In reality there a mutliple URL references and NAMEs so it would be very helpful to create a URL path from a couple NAME fields (or atleast from one in the same record/row)

far easier than I thought,


Right click on Column header and choose Customize field type,


Set field type to “Link to another record” choose the same table you are using.


Right click on Column header and choose Customize field type, (yes again)


Set field type to “Formula”


Then in the formula form put in the following:


CONCATENATE(“http://basepath/",Name,"/index.html”)


You can nest it like any other formula.


The part that was missing for me was even if you want to use the same exact row from the same table you still need to tell it to link to another record (This made no sense because I wanted it to link to the same record in the same table), IMO, it should be called (“enable record linking”) but it works.