0

Problem N:1 Activity_Name

CrossTab.ninox

On Staff Hour table, I create Activity_Name (N:1 'Staff Hours' To Activitires) for select the Activity.

With the Add Register button add the info to '  History Hours' but no find the way to 'Activity_Name' place the Name, only place a number.

5 replies

null
    • Fred
    • 10 mths ago
    • Reported - view

    Change the Show data as part of the reference field. It is under More Options.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 10 mths ago
      • Reported - view

      Fred Hi Fred,

      Yes, but the problems is that no transfer the info to 'History Hour' , transfer all less the Activitie_Name' only transfer the Number 3 no the Activity Name

      Have some problem on button Add Register.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 10 mths ago
      • Reported - view

       

      let me := this;
let myA := Activity_Name;
let newL := (create 'History Hours');
newL.(
    'N1_Staff Hours' := me;
    'Staff:' := me.'N1_Staff Project'.Name;
    'DestID:' := me.ProdID;
    'Hours:' := me.'Hours Weeks';
    'Week:_' := me.Week;
    'Activity:' := me.Activity_Name
);
'Hours Weeks' := null;
Activity_Name := 0

      Work all less the.       'Activity:' := me. Activite_Name

    • Fred
    • 10 mths ago
    • Reported - view
     said:
    transfer all less the Activitie_Name' only transfer the Number 3 no the Activity Name

     It is probably because you are not pointing to a text field. The field 'Activity_Name' is a reference field. In 'History Hours' the field Activity is a text field. The code in your Add Register button is:

    let me := this;
let myA := Activity_Name;
let newL := (create 'History Hours');
newL.(
    'N1_Staff Hours' := me;
    'Staff:' := me.'N1_Staff Project'.Name;
    'DestID:' := me.ProdID;
    'Hours:' := me.'Hours Weeks';
    'Week:_' := me.Week;
    'Activity:' := me.Activity_Name
);

    So on line 10 you are telling Ninox to only copy the record Id to the field 'History Hours'.Activity. Maybe try the following change:

    'Activity:' := myA.'Activity Name'

    or if you want to use the me variable:

    'Activity:' := me.Activity_Name.'Activity Name'

    If you do use the me variable then you can get rid of the myA variable since you don't use it all.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 10 mths ago
      • Reported - view

      Perfect Fred.

Login to reply

Content aside

  • Status Answered
  • 10 mths agoLast active
  • 5Replies
  • 48Views
  • 2 Following