Need help with an expression based on prefilled data

[Binkodyl]

I’m trying to create an expression to show a value based on a prefilled column called source, of which the value is set by a parameter in a URL. [Source] is the identifier that allows me to reference the row to a parent in another table. The current expression I’ve come up with is IF(Request[Source]=”Company1”,Select(Contractor[Logo], [Name] = “Company1”),Select(Contractor[Logo], [Name] = “Company2”))
Is there a better way to do this or a different expression I should use?

[Steve]

Binkodyl:

of which the value is set by a parameter in a URL

What in the world does this mean?

Binkodyl:

The current expression I’ve come up with is IF(Request[Source]=”Company1”,Select(Contractor[Logo], [Name] = “Company1”),Select(Contractor[Logo], [Name] = “Company2”))
Is there a better way to do this or a different expression I should use?

Maybe this:

LOOKUP(
  [_THISROW].[Source],
  "Contractor",
  "Name",
  "Logo"
)

See also:

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

[Binkodyl]

Steve:

LOOKUP(
  [_THISROW].[Source],
  "Contractor",
  "Name",
  "Logo"
)

When I use this expression, I get the following error; The expression is valid but its result type 'Thumbnail' is not one of the expected types: Show.
When I set the column type to thumbnail, The image doesn’t show in my form.

[Steve]

Use the LOOKUP() expression in the Show column’s Content setting:

[Binkodyl]

I made a url that prefills the column “Source”.
https://www.appsheet.com/start/8f6142f6-d409-4fc9-aa4c-77d013237c66#_restore=true&appName=GetQuote-1...