insert multiple lines in a subform.

Unread post by **kev1n** » Thu Jul 15, 2021 9:27 pm

It would also make it a great deal easier if you could create a minimal example that form/subform together with some dummy data. Then upload the db dump here so I can further assist you.

johan · Unread post by **johan** » Fri Jul 16, 2021 1:08 pm

Kev1n

Here's my printscreen
Johan

Unread post by **kev1n** » Sat Jul 17, 2021 6:24 am

Is new data entered in (1) and then before saving, it should check if (1) does not exist in (2) ?

johan · Unread post by **johan** » Sat Jul 17, 2021 6:49 am

Kev1n

When entering a new activity, user must enter 1.
Based on this info, 2 must be entered before saving or maybe even better with object RUN.
In this example I entered an activity that takes place weekly between 15 and 22/7.
Employee afterwards still must have the option to make changes in 2?

Johan

Unread post by **kev1n** » Sat Jul 17, 2021 6:55 am

Can't (2) be generated automatically from (1) when the form is saved? For each day a row is added to (2)

johan · Unread post by **johan** » Sat Jul 17, 2021 7:32 am

Yes that's the idea for a new form.
I have to check with SQL that the room is available on that moment.
When available fill in the room, if not add date, hours and leave room empty so user can choose An other room

Unread post by **kev1n** » Sat Jul 17, 2021 7:47 am

Could you also post a screenshot of the db columns of the main form?

johan · Unread post by **johan** » Sat Jul 17, 2021 8:12 am

Printscreen in attachment.
Johan

Unread post by **kev1n** » Sat Jul 17, 2021 8:53 am

Could you export the db schema of these two tables to an .sql file? Then I'll try to create a demo on our test platform.

johan · Unread post by **johan** » Sat Jul 17, 2021 9:55 am

Kev1n
SQL export of my tables.
We'll use this database for our work in a prison.
So I have to add extra conditions in my select query when a room can be used.
Every room has his max capacity and a room is in a section of the prison. Every section also has it's max capacity. But SQL is not a problem.

nuBuilder Forum

insert multiple lines in a subform.

Re: insert multiple lines in a subform.

Re: insert multiple lines in a subform.

Re: insert multiple lines in a subform.

Re: insert multiple lines in a subform.

Re: insert multiple lines in a subform.

Re: insert multiple lines in a subform.

Re: insert multiple lines in a subform.

Re: insert multiple lines in a subform.

Re: insert multiple lines in a subform.

Re: insert multiple lines in a subform.