Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Subform Type Form

BenFranske
Posts: 13
Joined: Fri Feb 07, 2014 10:54 pm

Subform Type Form

Unread post by BenFranske »

Does anyone have an idea about how to make Subform Type "Form" usable? I'm trying to build a subform of this type. When I do so I have several issues.

First, and most importantly, as soon as I click in the first field of the subform to fill it out another set of subform fields appears. Unfortunately they write over the top of the remaining subform fields, shifted down one row like a table type subform would (instead of down after the last subform field, or better yet on an additional page in the subform like MS Access does). In my case there will only ever be one set of subform fields attached to the form so I don't even need (or really want) the additional set of fields at all.

Second, although I can control subform height I am unable to control the main form height as far as I can see. This presents a problem with a long subform as it goes off the bottom of the main form screen and there is no scrollbar on the main form to continue scrolling down.

Solutions/ideas are appreciated! Thanks!
sbigelow
Posts: 15
Joined: Mon Mar 23, 2015 8:39 am

Re: Subform Type Form

Unread post by sbigelow »

Im finding you can pretty much manipulate any form using jquery. I started learning jquery the other day and its fairly easy to learn. I don't know the answer to you first question but here is how I solved the second part.
Second, although I can control subform height I am unable to control the main form height as far as I can see. This presents a problem with a long subform as it goes off the bottom of the main form screen and there is no scrollbar on the main form to continue scrolling down.
Just enter this code on the JavaScript section of the form you are wanting to change.

Code: Select all

$( document ).ready(function() {
    $('.nuTabArea').css({
height: '870px'
})
});


$( document ).ready(function() {
    $('.nuStatusHolder').css({
top: '878px'
})
}); 
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Subform Type Form

Unread post by admin »

Ben,

Have you looked at the wiki?

http://wiki.nubuilder.net/index.php/Forms

Steven
BenFranske
Posts: 13
Joined: Fri Feb 07, 2014 10:54 pm

Re: Subform Type Form

Unread post by BenFranske »

Yes, I have and doh! somehow I completely missed the height option on the form page.

Any ideas on the subform writing over the top of itself? See this example:
Image
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Subform Type Form

Unread post by admin »

Ben,

Send a picture of your subform problem.

Steven
BenFranske
Posts: 13
Joined: Fri Feb 07, 2014 10:54 pm

Re: Subform Type Form

Unread post by BenFranske »

There's a screenshot in my last post.
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Subform Type Form

Unread post by admin »

Ben,

What do you have set here..
Capture.PNG
Steven
You do not have the required permissions to view the files attached to this post.
BenFranske
Posts: 13
Joined: Fri Feb 07, 2014 10:54 pm

Re: Subform Type Form

Unread post by BenFranske »

Sorry about that!

Image
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Subform Type Form

Unread post by admin »

Ben,

If your Subform Type is 'Table' you will need to make your Row Height more like 200. But you might be better off setting it to 'Grid' and Row Height more like 25 or 30.

Steven
BenFranske
Posts: 13
Joined: Fri Feb 07, 2014 10:54 pm

Re: Subform Type Form

Unread post by BenFranske »

I would prefer to keep it as the "Table" (looks like this is actually called "Form") as there will only be one subform entry per record on the main form. Is there a way to prevent the additional record entry fields from being displayed at all since they will not be needed? A way to capture the onClick event and prevent it from generating a new set of fields?
Locked