Hello all,
I have already looked for 6 hours on somehow to find a solution to my problem. Let me put it this way:
I have a column named in_out (int), that identifies if a given record is an incoming or outgoing document; (1 = incoming & 2 = outgoing). I have already modified some to my needs like view as setting (for the list page):
if ($data["in_out"] == 1) $value = "Incoming";
if ($data["in_out"] == 2) $value = "Outgoing";
and before add/edit page events:
if ($values['in_out'] == "Incoming") $values['in_out']=1;
if ($values['in_out'] == "Outgoing") $values['in_out']=2;
and many other things, but a problem halted me in continuing.
In the way when we do a advance search panel or advance search, which btw I set them as a lookup list, so that they show Incoming and Outgoing as selection.
So there goes the problem I don't know to where to change the submitted search value and substitute it, where "Incoming" will be 1 and "Outgoing" will be 2 before the search happens.
Please help. Thanks for reading.