A lookup field does not update when the form is modified in the Form Designer

Support
1

Hello,

I created a Form using Form Wizard. Very simple form where data source is a table and the first field is a _Lookup.
Running the application: no issue. I browse the list, the lookup field is updated each time as I select a new record in the list.

image
image1456×772 44.1 KB

Then I modify the size of only one field using the Form Designer. Save the app and re-run it again.
This time, the lookup field is updated for the first selection,. but when I select a new record in the list, the lookup field always remains empty.

image
image1598×772 53.6 KB

Note: the problem happens also on the mobile version.

Something more I should do in the Form Designer?

Thanks!

2

Hi Jean, thanks for the question!

I have two follow-up questions to make sure I understand the problem correctly:

  1. Can the record be saved even though the lookup field is empty?
  2. If the answer to question 1 is yes, what happens when you export this table’s data as a CSV? Does the lookup field contain a value (i.e. the foreign key) inside the CSV?
3

Yes the record is saved, no data lost. The foreign key is present in the csv file.

I can even modify the lookup field in the form. When I click the field, the value appears and the drop down shows up with the correct values.

4

Example on the following animated gif:
emptyfield

5

Thanks for the additional information, Jean, I’ll pass this on to our QA team for further review. It appears to be a display problem (rather than a data problem, since the record is stored correctly). We will get back to you. Please allow for a few days, as most of our company is off for the Christmas break.

6

No problem, and Merry Christmas ! :slight_smile:

7

Hi Jean,

I am trying to reproduce the issue that you are having. Could you please just double check the steps I have performed to see if we have any differences as I can’t reproduce it, however, I can see in your images that the data is not displayed in the field.

To begin with I am using Windows and Edge browser.

  1. I created two tables, Product and Customer, the Customer table has a foreign key to the Product table. (Created by table wizard.)
  2. I created two forms in the form wizard each one referenced the tables. The first field in the Customers form is the Product lookup.
  3. I ran the app, added data in the Products form and then data in the Customers form. (Product lookup is showing all correct values in the lookup.)
  4. I then selected different records in the list and the Product field held the value.
  5. I went back into Five and with the Form Designer, resized the second field (as this is the field you have changed in your image).
  6. Then I re-ran the app and I am getting all the values still displayed in the Product field for all the saved Customer records.

My second field that I resized has a Date data type and display type as I was trying to set up your scenario as best as possible.

Could you please tell me are you using Windows or Mac and what browser are you using.

Kind regards,
Jo

8

Hello Jo-Anne

I reproduced the issue with the steps you describes. I joined the fdf to this message

  • I build the app on Windows with Edge browser.
    image
    image300×169 8.79 KB
  • Tables and Forms were built with Table & Form Wizards
  • The app runs ok.
  • I modified the size of the address field of the Form Customer using the Form Designer
  • Run the apps again and the lookup field does not update itself anymore.
  • Issue reproduced when the application runs on:
  • Windows Edge
  • Windows Firefox
  • IPad Chrome
  • IPhone Safari (mobile form version)
    Here is the animated gif of the app running on Edge:
    lookup-issue

TestLookup-20241229-152727306019752.fdf (3.4 MB)

Hope this help!

9

Hi Jean,

As per our emails, when you can, could you please see if this is working correctly for you now?

Kind regards,
Jo

1 Like
10

Yes the issue is fixed with the latest release. Thank you!