0

I have three tables, Employees, Job Numbers and Time. In time you link to an employee in the employee table and a job number in the job numbers table and all works great. However I have tried to build a control panel to link to the two tables but it wont work. I can build it in employees and it will create a record in time but not link to job numbers and visa vesa if built in job numbers. Is it possible to build a control panel in Time to enter the record and link to two other tables? If so can someone help with how I would link them? Below is the code I used in the employee panel.

let x := dialog("Add New", "Add New Time Record", ["No", "Yes"]);
if x = "Yes" then
let xCurrRec := Id;
let xNewDateWorked := 'DATE WORKED';
let xNewJobNumber := 'JOB NUMBER';
let xNewNorm := NORM;
let xNewThalf := 'T HALF';
let xNewDoub := DOUB;
let xNewTrav := TRAV;
let xNewSick := SICK;
let xNewLeave := LEAVE;
let xNewTtaken := TTAKEN;
let XNewPhol := 'P HOL';
let i := (create Time);
i.('Date Worked' := xNewDateWorked);
i.(Norm := xNewNorm);
i.('T Half' := xNewThalf);
i.(Doub := xNewDoub);
i.(Trav := xNewTrav;
i.(Sick := xNewSick);
i.(Leave := xNewLeave);
i.(TTaken := xNewTtaken);
i.('P Hol' := XNewPhol);
i.(Name := xCurrRec);
'DATE WORKED':= null;
'JOB NUMBER' := null;
NORM:= null;
'T HALF' := null;
DOUB := null;
TRAV := null;
SICK := null;
LEAVE := null;
TTAKEN := null;
'P HOL' := null;
end

3 replies

null
    • Support
    • 4 yrs ago
    • Reported - view

    Dear Steven, 

    We would be pleased if you present your task in our free webinar so that we can provide you with assistance.

    At our Ninox webinar tips and tricks will be presented in the first 30 minutes, the remaining 90 minutes will be used for live support where the participants' concerns will be solved. 

    You can register here for the webinar, which takes place every Tuesday at 18 o'clock CEST: https://zoom.us/webinar/register/WN_zoSk2qyNSz6vLRFF1zlakg 

     

    Best, Jörg

    • Steven_Johnson
    • 2 yrs ago
    • Reported - view

    All sorted Thanks.   I find it too hard to attend these seminars as they are in the middle of the night here in Australia.

    All the Best Stevej

    • Robert_N
    • 2 yrs ago
    • Reported - view

    I am having a problem creating a command in my control panel. What I'm doing is creating a point system that has a attachment to my end of night paperwork. I currently have two seperate buttons making one or the other. What I would like to do is merge those buttons together so I do it at the same time while connecting them. Here is what i've done so far.

     

    let x := dialog("Start Day", "Would You Like To Start Your Day", ["No", "Yes"]);
    if x = "Yes" then
    let xCurrRec := Id;
    let xDate := Date;
    let xEmp := Associates;
    let xStore := Store;
    let i := (create Points);
    i.('Main Page' := xCurrRec);
    let d := (create 'End of Night');
    d.(Date := xDate);
    d.(Associates := xEmp);
    d.(Store := xStore)
    end

     

    Please help if Possible

Content aside

  • 2 yrs agoLast active
  • 3Replies
  • 903Views