Dominic Potts asked 11 months ago
Hi, I am currently building a "web application" and what I'm trying to do, might just not be possible or it's a limitation of my knowledge of Formidable forms and not being a developer! I have a form, where I want put in the following information
Supplier Name, Address, Telephone - easy so far.
The next bit is where I'm getting into a muddle. I have a list of materials (setup in a separate table) I want to be able to select those materials and then put a selling price associated to that material for that supplier.
e.g.
Supplier 1 Contact Details
Material 1 Checked £20
Material 2 Unchecked
Material 3 Checked £25
My next step would then to be create a view showing the Suppliers, Materials and Pricing. Is this possible or am I being overly ambitious. Thank you Dominic
Dominic Potts answered 11 months ago
Please login or Register to submit your answer
"I have a list of materials (setup in a separate table" Are the material prices in this table as well?
Victor,
Thank you for responding.
So, I want to use that list to add different prices for those materials, for each supplier. The reason for having the materials in a list, is so we can update the list of materials.
Dominic
I think your best bet is to use a repeater field. Use a dynamic lookup and empty field for the price. I like dynamic fields because of their flexibility to display lookup details. Here are a couple of Formidable KnowledgeBase articles that can help:
https://formidableforms.com/knowledgebase/repeatable-section/
https://formidableforms.com/knowledgebase/dynamic-vs-lookup-fields/