Hello,
I am very very close to finishing my app! My Director is very impressed with what I have done so far - I just need some help with 3 outstanding issues that I am having.
1. - Filtering Issue numbers.
I have 3 forms in question,
Drawings,
Issue_no, and
Work_Order. When the user creates a new Drawing in the
Drawings form, they also create a new Issue no in the
Issue_no form which is a
sub-form within the
Drawings form. When the user selects the drawing from the
Work_order (via. a look-up field) - how do I filter the Issue numbers that are related the drawing number, rather than show all of the Issue numbers.
2. - Reference numbers
Doing some research on Google / Zoho forums - I was able to write some Deluge script that saved a reference number on a form called
Reference_numbers and when the user creates a new Works_order the reference number is attached and then updated so every Works Order has there own unique number. This all works fine. But I wanted to do the same with a Purchase order and then a Delivery note. When I copied the code, added the related fields, and modified the script to suit I get the following error:
Error:
Error details:
Error occured while on Validate script.
Unable to update variable Reference_numbers
Value for the field x.PON is null.
The code I used was:
#
Code:
- x = Reference_numbers [ID != 0];
- Reference_numbers = (x.PON + 1);
- x.PON = (x.PON + 1);
- input.PON = x.PON;
3. - Setting a multi-select box.
I have a drop-down box called Status and it has 3 possible options: "Not-started"; "In-progress"; and "Finished". I have set the properties of the field so that it is on "Not-started" by default, which works. But when this form is used as a
sub-form and the main form record is created, the Status (via. the sub-form) is being set to blank. How do I make the it "Not-started"?
I hope some of this makes sense - if you have any questions then I will try and explain it as easily as I can. I have access for support for any employee's who may be able to help.
Thanks in advance
Ben