0

Way to Assign multiples fields to another table.

1Resources.ninox

Hi. Attach a Dummy DB.

Table 'Hours by Resources' and table 'Documents'

It is necessary to assign each categorie for each document.  Each document can have several categories.

Example the first document Discipline Process need to assign the 3 Categories P7,P6 and T4 with the associated hours.

6 replies

null
    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 mths ago
    • Reported - view

    I need to sum the Rate that is checked in Multiple Choice dynamic,  and the data is in the 'Hours by Resources' table.

    Each document can 1 or the four categories.

      • Fred
      • 2 mths ago
      • Reported - view

      if you need a hint on how to get started, try setting a variable using the record() command inside a for loop with the numbers() command around the dynamic multi choice field. then you can sum() the variable.

      let us know how it goes.

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

       

      NO Way Fred up to here no more ideas come

      let choices := numbers(record(this).['Category & Rate']);
      for x in 'Category & Rate' do
          let recordValue := record('Hours by Resources', choice);

      • Fred
      • 2 mths ago
      • Reported - view

      that is a good start. Try this:

      let x := for loop1 in numbers('Category & Rate') do
        record('Hours by Resources',loop1).'Rate bt Categ'
    end;
sum(x)
      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

       

      Hi Fred this work great thanks.

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

       

      Other similar way 

      let total := 0;
for loop1 in numbers('Category & Rate') do
    total := total + record('Hours by Resources',loop1).'Rate by Categ'
end;
sum(total)
Login to reply

Content aside

  • Status Answered
  • 2 mths agoLast active
  • 6Replies
  • 55Views
  • 2 Following