Vin Decoder? No =LEFT() function?

By: Erik Meeder | Asked: 11/15/2024
ForumsCategory: General questionsVin Decoder? No =LEFT() function?
Erik Meeder asked 4 weeks ago
How could a vin decoder be implemented into a form? I have database of vin/year/make/model/. I use the lookup feature currently.  but would love to make it so that if there is only 1 option available, then it will automatically fill in this option, instead of having to select it in the drop downs.   also is there a way that only the 1st 8 characters of a field can be copied into another 'calculated field'? Basically it would be like the excel formula  =LEFT('field',8)   Thanks  
2 Answers
Victor Font answered 3 weeks ago
Yes. Use jQuery if you want the field copied in the browser, or PHP if the calculation takes place on the server.
Erik Meeder answered 3 weeks ago
Thanks i got the JQuery set up for the copying parts of a field to another field. Ill briefly explain my 2 fields. I set up jQuery to populate a 'Lookup Field' with a character from another field. Lets say the character that automatically populates is "A". I have another form with 2 columns where  "A"  in column A shows '2010' in Column B (data for my lookup field) I have a second 'Lookup Field' (dropDown) that returns Column B based on input of the 1st LookUp Field. I do see the correct result in the dropdown as the only option to select. But i really would like this result to autocomplete? There is a option in the Lookup Options where i can check "autocomplete".  I was hoping this would automatically fill in the only option available. what is this option for? Is there anyway i can autopopulate when the result is only 1 option? Perhaps by changing the 'Display Type' in Lookup Field? BTW i also tried to add a Page Break, hoping this would result in the field populating but didn't make any difference. Thanks for your help and prompt replies.  
Victor Font replied 3 weeks ago

I'm confused by your explanation, but it sounds like you want to use cascading fields. By using the term 'lookup field' and saying you're populating it with jQuery doesn't make sense. The term 'lookup field' in Formidable is about different field types that retrieve their content from the database. Lookup fields can be dynamic which are of great value to application design and reporting.

You can make anything self-populating with default values or using the frm_setup_new_fields_vars and frm_setup_edit_fields_vars filters.

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right