Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Field that links to actual project expense in Expense Report

Avatar

Level 3

Hello WF Community,

Does anyone know if there's a field that you can add to an Expense report that will link to the actual expense line item on the project? I'd love for my finance person to be able to go and look into a specific expense by clicking on this link as opposed to clicking on the overall project name.

Thank you!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 4

Yes, all you need to replace is the valuefield to description instead of ID. See below:

case.0.comparison.leftmethod=val(templateID)

case.0.comparison.operator=nn

case.0.comparison.operatortype=string

case.0.comparison.truemethod=nested(template).HTML(name)

displayname=Expense Description

link.comparison.leftmethod=val(referenceObjID)

link.comparison.operator=nn

link.comparison.operatortype=string

link.comparison.truetext=

link.linkproperty.0.name=ID

link.linkproperty.0.valuefield=topReferenceObjID

link.linkproperty.0.valueformat=string

link.lookup=link.view

link.nestedobjcode=string(topReferenceObjCode)

link.nestedobjid=string(topReferenceObjID)

link.value=val(topReferenceObjCode)

textmode=true

valuefield=description

valueformat=HTML

View solution in original post

4 Replies

Avatar

Level 4

Try adding the text below:

case.0.comparison.leftmethod=val(templateID)

case.0.comparison.operator=nn

case.0.comparison.operatortype=string

case.0.comparison.truemethod=nested(template).HTML(name)

link.comparison.leftmethod=val(referenceObjID)

link.comparison.operator=nn

link.comparison.operatortype=string

link.comparison.truetext=

link.linkproperty.0.name=ID

link.linkproperty.0.valuefield=topReferenceObjID

link.linkproperty.0.valueformat=string

link.lookup=link.view

link.nestedobjcode=string(topReferenceObjCode)

link.nestedobjid=string(topReferenceObjID)

link.value=val(topReferenceObjCode)

shortview=true

valuefield=ID

valueformat=HTML

width=10

This should make the Expense ID a clickable link

Avatar

Level 3

Thank you so much Mike! This works beautifully.

I was wondering, however, is it possible to swap out the ID and link the Expense Description? Thank you!

Avatar

Correct answer by
Level 4

Yes, all you need to replace is the valuefield to description instead of ID. See below:

case.0.comparison.leftmethod=val(templateID)

case.0.comparison.operator=nn

case.0.comparison.operatortype=string

case.0.comparison.truemethod=nested(template).HTML(name)

displayname=Expense Description

link.comparison.leftmethod=val(referenceObjID)

link.comparison.operator=nn

link.comparison.operatortype=string

link.comparison.truetext=

link.linkproperty.0.name=ID

link.linkproperty.0.valuefield=topReferenceObjID

link.linkproperty.0.valueformat=string

link.lookup=link.view

link.nestedobjcode=string(topReferenceObjCode)

link.nestedobjid=string(topReferenceObjID)

link.value=val(topReferenceObjCode)

textmode=true

valuefield=description

valueformat=HTML

Avatar

Level 3

Amazing, thank you so much Mike!