SIGN UP

Lookup Fields are Blank After Bulk Import

By: Awodele Omilami | Asked: 08/31/2024
Forums › Category: How-to › Lookup Fields are Blank After Bulk Import
0 Vote Up Vote Down
Awodele Omilami asked 2 weeks ago
  1. I am using a lookup field in form B, using data from form A.
  2. When I export the data from form B and then import it back, my lookup field is now blank when I go to edit the record even though the data in the CSV perfectly matches the data in form A.
  3. After import I have to click entry by entry and update those blank fields, and I have over 9,000 records.
  4. Is there a way to populate my lookup field without going record by record? Please help.
1 Answers
0 Vote Up Vote Down
Victor Font answered 2 weeks ago
What kind of lookup field are you using in Form B, dynamic or standard lookup?
Awodele Omilami replied 2 weeks ago

Standard Lookup. After Import, when I view my entries through the Formidable back-end "Entries" page I can see the field contents, but when I click "Edit" and go inside the record the field is blank and I have to manually click the Lookup dropdown and reselect the answer. After my import, about 60% of the fields are blank, and about 40% are there when I click edit. I appreciate your help.

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