If only I could achieve this

Ask the community
1

I have an Airtable table (called product) that holds product information across 3 fields in a table, namely Product_Make, Product_Line and Product_Model and is indexed on a formula field that combines these as make_line_model.
I have another table (Purchased) which has a text field of data supplied by clients that have purchased products and I need to match it to data in the first table. So imagine a ‘purchased’ field that has ‘make_line_product’. So example data would look like:

Product table:
Make: Dell
Line: Latitude
Model: 1234C
Index: Dell_Latitude_1234C

Purchased table:
Product: Dell Latitude Laptop 1234 C

I want to create a Softr screen that shows the row from the Purchased table and then allows the operator to ‘find’ the matching record in the Airtable product table, ideally being able to filter matches by Make, Line and Model and then selecting the match and therefore correcting the input on the Purchased table.
You can sort of do this natively in Airtable by clicking on the + in a linked record field, but that only displays the indexed field, you have no option to filter by the other 3 fields.
Ideally, when the Product in the Purchased table matched the ‘make_line_model’ in the Product table, then the Airtable link would be created automatically.

Am I making any sense? Ideally I would employ someone with Airtable/Softr experience but we’re a non-profit and I have a negative budget.

2

@Bitstreams do you want to do this automatically or rather a manual step ?

3

I think I would like the operator to be able to choose the right product manually - I can make the link happen automatically on the import I think.

4

I think you can create a table of purchases in Softr and each line could have assign button which opens a edit modal with linked record of product and that has a search typically and they can just type the name ?

5

I have had a look at this, this morning. If you use an in-line button to ‘edit/update’ the record, you can only specify fields in the Airtable table that the block relates to. So you can only specify the linked record ‘Product’ and not access the fields in the ‘Products’ table - namely Make/Line/Model.
I can make it so that it offers a drop-down of the available Products through that linked field, but this is essentially the same functionality that you get in the Airtable UI anyway, so gets me no further.
What I need is the ability to access fields from more than one table in the same Table Block - and I guess that functionality is beyond Softr at present.

6

If one button click without input would do it then I guess you can fully automate without clicks ?