Forums: Read Only Lookup Field - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

Read Only Lookup Field Rate Topic: -----

#1 User is offline   i.NoLim 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 88
  • Joined: 11-September 17

Posted 06 March 2019 - 11:06 PM


I have 4 fields: FiscalYear, Department, Account and Remainder. I would like for Remainder to be a read only value that auto populates depending on the other 3 fields. I already tried "This dropdown is dependent on...," in fact Department is dependent on FiscalYear and Account is dependent on both FiscalYear and Department, and it works... sometimes. Sometimes it acts a bit funky where after selecting the other 3 values the correct Remaining value flashes really quickly but its not selected and I'm not able to do so, only "Please select" is available. Additionaly, I was not able to figure out how to make it read only (HTML?).

I'm guessing it will be a Javascript onload Event that checks when Account changes, as that's the last field being selected, and then does a SQL query.

Any help would be appreciated.

Thank you!

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users