Forum Discussion

JordanBeatty1's avatar
JordanBeatty1
Qrew Captain
8 years ago

Altering a form without changing a table

I've been working on helping automate work flow process on quick bases in apps I didn't design. Currently, when people are logging their hours, they are using a drop down menu tied to a table with their information in a different app to select who they are. I would like to change it so it auto fills to the current user. I was able to do this though, when I alter the form in this way it wipes the rest of the inputs in that field. Is there a way I can alter the form and not allow the table to retain its previous information?
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    Those other fields that get wiped are either lookup fields or conditional fields.

    By design, when a 2nd field is conditional upon the 1st, and the 1st changes, the 2nd needs to change as well (normally to blank).  

    There might also be a form rule that is changing those values.

    Hard to tell what might be causing it without seeing it, but those are some ideas.
  • Yes, originally it was a lookup field. I changed it so that the current value will default to the user unless you're an admin. I just hoped there was a way to allow the data to stay and not go blank and allow entries after I had made the change to go by the new form rules.