Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Return Field Names that Contain Search Text / Values

Solved
Jump to Solution
1647 2
cancel
Showing results for 
Search instead for 
Did you mean: 
C_Boyd
6 - Interface Innovator
6 - Interface Innovator

Airtable Gurus, I need help!

I’m looking for a way to return all the field names that contain a certain value. Let me explain:

I’m gathering documents from clients, and I’ve sent them a survey asking them what types of documents they have, and in what form.

The survey contained multiple questions along these lines:

Do you have documents relating to Topic X? Check all that apply:
[ ] Emails
[ ] Hard Copy Documents
[ ] Electronic Documents

As a result, I have many multiple-select Document Category Fields that contain one or more of the “Document Format” responses (e.g., “Emails,” “Hard Copy,” etc.).

What I’d like to do is now generate a list for each client of all the documents they said they had, so that I can follow up on each category and ensure that we’ve collected everything they have.

The way I imagine this working (although I’m open to other suggestions), is a single field for each document category, which would search in each Document Category Field for a particular Document Format, and return a list of all Document Category Fields that contain that particular Document Format.

So… I would have a Field called “Has the following [Document Format] Documents” that would contain a list of [Document Categories]. E.g.:

FIELD:
Has the following Hard Copy Documents:

RESULT:
Documents Relating to Topic X
Documents Relating to Topic Y
Documents Relating to Topic Z

I’ve been fussing with nested IF statements and AND/OR operators for an hour, and I just can’t seem to get it to work right.

Please help?!

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

Here’s one solution:

Screen Shot 2019-03-07 at 1.42.12 PM.png

The formula fields are all similar (only the search parameter changes), so I’ll only break down the first one:

IF(
    SEARCH(
        "Hard copy",
        {Topic X}
    ), "Topic X\n"
) &
IF(
    SEARCH(
        "Hard copy",
        {Topic Y}
    ), "Topic Y\n"
) &
IF(
    SEARCH(
        "Hard copy",
        {Topic Z}
    ), "Topic Z\n"
)

Is that what you’re looking for?

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

Here’s one solution:

Screen Shot 2019-03-07 at 1.42.12 PM.png

The formula fields are all similar (only the search parameter changes), so I’ll only break down the first one:

IF(
    SEARCH(
        "Hard copy",
        {Topic X}
    ), "Topic X\n"
) &
IF(
    SEARCH(
        "Hard copy",
        {Topic Y}
    ), "Topic Y\n"
) &
IF(
    SEARCH(
        "Hard copy",
        {Topic Z}
    ), "Topic Z\n"
)

Is that what you’re looking for?

C_Boyd
6 - Interface Innovator
6 - Interface Innovator

Yes! So simple, yet the exact syntax was totally evading me. Thank you so much!!!