Page 1 of 2

Pizza Tutorial missing in video

Unread postPosted: Wed Dec 09, 2020 9:23 pm
by apmuthu
Ref: Pizza Video Tutorial 3
https://www.youtube.com/watch?v=40aWH3Gqn28

After setting up the invoice table's fast form, the part where the Customer is looked up is missing.

Even after manually doing all the steps, I see that the customer_id is being displayed and something is amiss in the invoice form as well where the lookedup value is shown in the right and the customer-id is being displayed!

Re: Pizza Tutorial missing in video

Unread postPosted: Wed Dec 09, 2020 10:41 pm
by kev1n

Re: Pizza Tutorial missing in video

Unread postPosted: Wed Dec 09, 2020 10:56 pm
by apmuthu
Yes.

There seem to be several sets of objects pertaining to invoice and item in the objects table.
Also the date on the invoice data is set to the year 1919 instead of 2019.

Actually, just the data pertaining to the tutorial should have been there for non cluttered understanding.

Re: Pizza Tutorial missing in video

Unread postPosted: Tue Dec 15, 2020 6:10 pm
by apmuthu
Had to alter it to cus_name (both Code and Description) after making and SQL in the SQL Builder for the inv_customer_id field as:
Code: Select all
SELECT
    invoice.inv_date,
    invoice.inv_number,
    invoice.inv_grand_total,
    customer.cus_name

FROM
    invoice
        JOIN customer ON customer.customer_id = invoice.inv_customer_id


If the Code and Description are the same in any Lookup definition, then the right side display of the Description should be suppressed in the nubuilder4 code itself instead of needing any js code. What is the standard js code in such a case in the meanwhile to suppress the Description display in the form?

Re: Pizza Tutorial missing in video

Unread postPosted: Tue Dec 15, 2020 7:17 pm
by admin
Hi,

Give this a go:

Code: Select all
nuHide('inv_customer_iddescription');


Could you log an issue on Github (as improvement)? Thanks a lot!

Re: Pizza Tutorial missing in video

Unread postPosted: Tue Dec 15, 2020 10:33 pm
by apmuthu
Whilst this does work in the AfterBrowse js code, the fact remains that the Description still shows up when a record is taken in for edit and the form is displayed anew.

Is there any documentation as to how each field is referred to in the js code?

Re: Pizza Tutorial missing in video

Unread postPosted: Wed Dec 16, 2020 12:05 am
by apmuthu
@kev1n: Thanks.
The custom code did it.
Code: Select all
if (nuFormType() == 'edit') {
    nuHide('inv_customer_iddescription');
}

Re: Pizza Tutorial missing in video

Unread postPosted: Fri Dec 18, 2020 10:45 am
by steven
apmuthu,

You can hide the Description by setting its length to 0.


Steven

Re: Pizza Tutorial missing in video

Unread postPosted: Fri Dec 18, 2020 4:14 pm
by apmuthu
@steven: Thanks. An example js / php code snippet and screenshot would be useful.

@kev1n: Thanks for indicating the browser console to identify the field name like inv_customer_iddescription

Re: Pizza Tutorial missing in video

Unread postPosted: Sat Dec 19, 2020 3:52 am
by steven
apmuthu,

Setting Width to 0 will hide the Description field.

descw.png
descw.png (26.83 KiB) Viewed 329 times



Steven