Show several functional directories on the form

Unread post by **kev1n** » Wed Mar 24, 2021 12:57 pm

Inspect the Browse SQL of your embedded Browse form with the developer console to verify that it gets updated and the syntax is correct.

browse_sql.png

I created a "Browse Filter" demo at https://test.nubuilder.cloud/

Login credentials (Admin rights in Demo Mode)
User: test
Password: nutest

User Home -> "Browse Filter"

for reasons of simplicity, I use strings for the departments (Department1, Department2) rather than Ids and Pks, Fks.

kknm · Unread post by **kknm** » Wed Mar 24, 2021 2:15 pm

I realized how far we do not understand each other

)
In your example, you do this on an EditForm, but I created an empty form on the 'Report with criteria' form as in the nuBuilder tutorial and of course I don't have an EditForm.
The fact is that I have a program in my office that collects data from all offices and uploads data to the database when the equipment changes. But I still need to maintain all this peripherals and, in addition to this data, keep service magazines based on 'departments', 'computers', 'printers', etc. ... I do not change anything in these directories, so I do not need to edit them - just Keep a log using their data. Now, as I understand it, I need to create magazines (BrowseAndEdit) and carry out all the manipulations in them. This is a little different ... I would like to first have an overview of all peripherals and choosing either 'Department', 'Computer', or 'Any device' to do further operations in different magazines by type of equipment.

Unread post by **kev1n** » Wed Mar 24, 2021 2:17 pm

If you don't have an Edit Form, what is it then? My example also works on a Launch form.

kknm · Unread post by **kknm** » Wed Mar 24, 2021 2:23 pm

kev1n wrote:If you don't have an Edit Form, what is it then? My example also works on a Launch form.

I do not see any objects and forms on your form, except for an empty table with the headers 'text' and 'select'.

Unread post by **kev1n** » Wed Mar 24, 2021 2:25 pm

I see this when I log in with the test user:

kknm · Unread post by **kknm** » Wed Mar 24, 2021 2:36 pm

I saw it ... But before that you need to click the Add button to get into the EditForm.
I don't have this button ...

wind.png

Unread post by **kev1n** » Wed Mar 24, 2021 2:38 pm

You can turn this Edit/Browse form into a Launch form. Let me do it...

Unread post by **kev1n** » Wed Mar 24, 2021 2:39 pm

It's now a Launch form.

kknm · Unread post by **kknm** » Wed Mar 24, 2021 3:03 pm

Now I figured it out - the id of the form 'Departments' ('fltr') matched the filter in SQL for 'Computers'

Code: Select all

SELECT
 COMPUTERS.*

FROM
    COMPUTERS

WHERE
    ((DEPARTMENT_ID ='#fltr#'))

Thanks !!!!

kknm · Unread post by **kknm** » Wed Mar 24, 2021 3:14 pm

Everything works, but for some reason it writes in the debugger:
VM11788:5 Uncaught ReferenceError: iniFrame is not defined
at <anonymous>:5:1
at b (jquery.js?ts=20210324170715:2)
at Pe (jquery.js?ts=20210324170715:2)
at S.fn.init.append (jquery.js?ts=20210324170715:2)
at nuAddJavascript (nuform.js?ts=20210324170715:3416)
at nuBuildForm (nuform.js?ts=20210324170715:189)
at successCallback (nuajax.js?ts=20210324170715:117)
at Object.success (nuajax.js?ts=20210324170715:17)
at c (jquery.js?ts=20210324170715:2)
at Object.fireWith [as resolveWith] (jquery.js?ts=20210324170715:2)

nuBuilder Forum

Show several functional directories on the form

Re: Show several functional directories on the form

Re: Show several functional directories on the form

Re: Show several functional directories on the form

Re: Show several functional directories on the form

Re: Show several functional directories on the form

Re: Show several functional directories on the form

Re: Show several functional directories on the form

Re: Show several functional directories on the form

Re: Show several functional directories on the form

Re: Show several functional directories on the form