Skip to main content
Solved

Lookup Name field in a URL field of the same record row

  • January 8, 2020
  • 2 replies
  • 21 views
M
Forum|alt.badge.img+6

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

So column 1 is field type NAME.
with the contents
Row 1 is fred
Row 2 is barney
Column 2 today is field type URL
Row 1 http://basepath/fred/commonpath
Row 2 http://basepath/barney/commonpath
What I want is Column 2 to have field type URL and effectively auto look up the NAME
Row 1 http://basepath/{NAME}/commonpath (look up NAME for row1)
Row 2 http://basepath/{NAME}/commonpath (Lookup NAME for row 2)
That way I can just copy the formula but all the URL links, in reality there a mutliple URL references and NAMEs so it would be very helpful

Best answer by Marshall_Johnso

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.

    2 replies

    M
    Forum|alt.badge.img+6

    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)

    M
    Forum|alt.badge.img+6
    • Marshall_Johnso
    • Author
    • Inspiring
    • Answer
    • January 13, 2020

    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.

    Terms & ConditionsAccessibility statement