Dereference using SELECT

Amit_Jain1 · 04-02-2019 04:09 AM

Here is regular formula for Same App
SELECT (Table Name[Column Name])

How do I create formula to pull data from. Another App

Any idea?

LeventK

@Amit_Jain
You need to add that another app’s table that you need as a table to your app.

Amit_Jain1

It worked

Thanks for reply

Amit_Jain1

One more Issue
I also want to Add “Blank” & “Plain” in Every dereference Result along with Match result

Steve

The results of a SELECT() are in a List. You can combine lists using the + operator (see the link below), so you can use + to add more items to your results, similar to this:

SELECT(...) + LIST(...)

Note, though, that the items you add should be the same type as the items in the first list: in this case, you should add references to rows for Blank and Plain, not just the words.

Amit_Jain1

Once again Thank for Suggestions