Help writing lookup formula

Hi all! Generally new to WeWeb and struggling a bit with a formula.

I have a Collection called “userDetails”. On the page I’m working on, I know the value for “userDetails.data.name”. I’d like to do a lookup to get the value for “userDetails.data.id”.

I feel like somehow either “lookup” or “lookuparray” and maybe “getkeyvalue” are involved, but I can’t seem to get the right formula. I also tried the AI Formula Generator and it didn’t provide anything that worked.

Any ideas please? :slight_smile:
Thanks!
Matt

getKeyValue( lookup( yourValueForName, userDetails), “id”)

1 Like