We have an interesting use case for our company.
I am almost 100% certain that what I want to do is impossible to achieve with JotForm, Airtable Forms, Softr Forms and miniExtensions forms.
I have a record.
The record’s fields are as so:
Name, Selected Option (linked field), Type.
I am trying to create a form where:
a) Selected Option is filtered by the Type field (the selected option record has the same type field which I keep updated so the single select options match)
b) The dropdown box in the selection field not only shows the name of the linked field but also an image associated with that linked field in airtable.
An example of this would be:
Name: Wall Colour
Selected Option table has a bunch of records like Blue, Red, Green, Rough Brick, Stainless Steel. It also has a type.
I want the Selected Option linked field to only show Blue, Red or Green, since those linked records have the type Colour which matches. However the type may change to ‘Metal’, in which case only Stainless Steel should be shown.
This is currently impossible with all known integrations. It is basically a conditional lookup based on another field rather than a hard-coded condition.
The other issue I have is that when selecting from a range of linked records, I want to show not only the name of those linked fields, but the image field in that linked record also.
I also believe this is impossible to achieve with any of the aformentioned tools.
If any of you have any other extensions / tools to recommend I would be truly grateful.
Of course the other option is I completely abandon no-code and just hire web devs and spend the tens to hundreds of thousands of dollars needed in order to achieve this myself. Its not outside the realm of possibility at the moment but I would rather not.