Como puedo actualizar los precios de mis productos.

Tengo un formulario donde necesito cargar una lista de productos pero el precio cambia dependiendo del cliente, es posible que me muestre el precio del producto ligado a un excel cargado en jotform, ejemplo selecciono el producto y la lista de precio y en base eso me traiga el precio.

Hi marcoxperia29,

Thanks for reaching out to Jotform Support. Our Spanish Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, it might take a while until they're available again.

Now, coming back to your question, we have a Spreadsheet to form widget that you can use to import your data, but it won't populate the Product List field. If you have a list of product that needs updating, you can use basic elements like multiple choice and single choice fields. Let me show you how to use it:

• Create a spreadsheet that includes your data in the structure you see below. It's important that the column names in the spreadsheet and field names on the form are the same.

• In Form Builder, click on the Add Form Element menu on the left side of the page.
• Under the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.

• In the Widget Settings window that opens up, upload your data file and customize the other options. 
• Then, click on Update Widget.

• In the final stage, add the fields to view values and name them the same as on the spreadsheet.

Give it a try and let us know if you require any help.