Hi @Juice, welcome to Honeycode and the Community! I'm happy to try to help you here. I would suggest that you take a different approach to your table set up. Specifically, try going with a many-to-many design. I'll walk you through the steps below:
Now, to pull the right allowance amount, using this expression: =IFERROR(FINDROW(Allowance,"Allowance[Insurance]=% AND Allowance[Item]=%",$[Picklist_Item],$[Picklist_Insurance])[Allowed],"$0")
For the formula box, I don't quite understand yet where you would pull the allowance remaining from, but assuming the allowance amount is from the table and copay is from the provided input field, you could do something like this: =($[Allowance_Amount]-$[Allowance_Remaining]*$[Copay])
I may have gotten some of the terms/labels/formula of your use case incorrect but hopefully you get the gist of this. Let us know how it goes and if you need additional help!
I'd like to add an input box, when I enter for example "apple", it can automatically go to 'self-funded companies' table to fuzzy matching and pull out 'it is self-funded company' or not.
Hi @Juice, we do not support fuzzy matching based on input fields today. I'll take note of this though for our product team to evaluate for the future.
In the meantime, depending on the specifics, you could potentially accomplish something similar by using a picklist. For example:
For the box below the image "Edit Value". I actually want to add an "if" index that if the companies are not in the picklist, then shows"not self funded company"; if it's in the picklist, shows "SleepCO"
Hey @Juice, could you elaborate a bit more of what you are trying to accomplish with that new input field? E.g. Sounds as if you want an app user to be able to type in a company name. And if that company name is not in the picklist (which is basically the self-funded companies table), then show a "not self funded company" message. But if it is, then display "SleepCO". Is that correct? If so, where would you want these messages displayed? Also, keep in mind that if you use an input field, the user would have to type the company name exactly as it was in the table, since Honeycode does not support fuzzy matching.