I know this has been a question going back years on Answers and it still does not seem to work and figure I would ask for suggestions. We continually run into this and are not able to provide our clients with solutions
I have a table that has a lookup rule tied to cost center. Its just a fill rule with a list of available cost centers from SQL.
What I would like is that if Fund Category = Employer simply default the Cost Center to 1000. No matter which of the following I do, the result is that if the 1000 goes into Cost Center automatically, all the other lookup choices are removed.
1. Use formula on cost center - IF (fundsource="Employer","1000",""). I removed the row index stuff to simply it. This works but again if they need to change it the drop down is gone or screws up other rows in the table.
2. Use a lookup rule to populate the cost center drop down (like above). Have an entire other SQL table that simply has one row with employer and 1000. Hook that lookup rule to the field as well. This works but I loose the other drop downs.
3. Change cost center to a list field. Put all cost centers in the list and check the "append to lookup choice". The defaults but again loose other lookup choices.
We continually run into this and users of the process are a little surprised that Laserfiche cant do this action at least through standard setups.
Is there javascript out there that could accomplish this?