Forum Discussion

MattHardy1's avatar
MattHardy1
Qrew Trainee
4 years ago

Form Preview Acts Different than Live Form

Hello,
I have a form that has multiple lookup fields from other apps, all of which work fine when using the form preview. When I save the form and try to use it, most of the lookup fields no longer work. Where should I start looking for the problem? Attached are screenshots showing the difference in the form preview and the actual form.

Here's a breakdown of what I'm doing:
- We work under multiple contracts, each of these has it's own app.
- I created an invoicing app with relationships to each of the contract specific apps, with the invoicing table being the child in each because each job under the contract app can have multiple invoices.
- The invoicing app needs to lookup a reference number from the contract app and store it in "Job" field. I might be complicating matters here, but I'm using a single job field to simplify the reports. I can display this one field, rather than each of the 9 lookup fields.

Thanks in advance for any guidance.

------------------------------
Matt Hardy
------------------------------

2 Replies

  • It looks like you probably have the settings on the form element for the LOI field set to show in Add, but not in Edit. I would double-check that.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • MattHardy1's avatar
      MattHardy1
      Qrew Trainee
      That was the problem. So simple. Thank you so much!

      ------------------------------
      Matt Hardy
      ------------------------------