Altering a form without changing a table

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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?
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb
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.