Interface Designer

[cshenoy86]

I have two tables in my base - Organisation (Fields: Name, Company Tag, Industry tag, location, Okay to fund) Funder (Fields: Name, Company tag, Industry tag) My interface needs to do the following:

1. Select a funder from the investor table.
2. Select the location country from the organisation table. I want to provide the user the flexibility to choose a location.
3. Match the company tag from the funder table to the company tag in the organisation table.
4. Match the industry tag from the funder table to the industry tag in the organisation table.
5. Show me a list of organisations for the above selected criteria sorted by okay to fund as yes.

I have tried building an interface where I can select a funder to show the two tags.
Now within each tag - I can show the list of organisation from the org table and the funders from the funder table. However I am kind of stuck with sorting to show only the okay to fund orgs and based on location. I want to understand how to use a filter that shows the results. Would I need to use a button or an automation? Or do I need to have multiple pages for this type of search UI?

[ScottWorld]

Unfortunately, Airtable doesn’t offer that ability, even though that has been one of the top requests from users over the last 9 years!

You would be required to turn to an external app to solve this problem for you.

I only know of 2 apps that can do this: Fillout and Noloco.

Fillout is an advanced form replacement for Airtable, whereas Noloco is a full-blown front-end replacement for Airtable that can act as both a portal and an interface.

I give a brief tutorial of Noloco on this episode of the BuiltOnAir podcast. I also presented a full one-hour webinar on Noloco called Building a Client Portal on Noloco powered by Airtable.

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting - ScottWorld 

[cshenoy86]

Does that mean it is not possible to create an interface that shows up results from two tables?

[ScottWorld]

If you start with a blank interface page (or any of the interface pages that allow you to drag your own custom elements onto the page), you can definitely display data from different tables,

[cshenoy86]

Okay. Thank you!