Converting an index match setup to Tadabase

[moe]

There is no native way of doing this, but I’m sure we can find a way.

Here’s a few ideas:

A) If you’re working with just a few basic values, you can use an equation field with IF statements.

How to use Equation Fields in your Tadabase app

B) If it’s somewhat more complex, you can use some JavaScript Pipe:

C) You can also the Rest API to lookup based on a single value, not exactly like Index and Match, you can see similar post here:

Calculate selling price automatically based on markup range cost falls into

Sorry about the delay. Here’s a video demonstrating how to do this with a pipe. I wish it was simpler, but hopefully this can help for now. Main issue with this which is still being worked on is that if the value falls on an exact number in the max or min field it will not work. For that we need an operator that is “higher than or equal to” and “lower than or equal to” [Using a pipe to do a lookup] Please let me know if you have any questions.

D) If you need a true Index and Match you can turn your a Google Spreadsheet into a standalone database and run a request against it in conjuction with a Pipe. This is complex.

I’ll make a video shortly to explain how to do this. It’s complex and will require advanced knowledge in Pipes and Google Sheets.