This topic is locked

Get Lookup value not ID

1/27/2025 9:00:56 PM
PHPRunner General questions
A
asawyer13 authorDevClub member

I have a lookup it shows value of name but links to ID. Normal stuff.

However I want to use the name value in a log.

How I can get the field value for the Name field, for example, rather than the ID?

I guess I could do a dblookup but would prefer to not have to query the database again.

Alan

C
copper21 1/28/2025

I do this often and I do use a query in the after add to fill in those values...I don't see any adverse affects.

Sergey Kornilov admin 1/28/2025

It really depends on where and when you need to get this value. Also, one extra query is not that huge of a deal.