0

How to create a column in a view with a sequential row number

I have searched the forum and did not find anything that directly answers this.

i have a table with two columns gross and net values.  I created two views each sorted by the Gross value and the net values.  I would like to add a new column to each view and have the value start at 1 in row one through x number of rows incrementing by 1 for each row.

example of the gross view.  The net view would also have 4 rows but different order.

Place   Gross

1            10

2            13

3            17

4            22

9 replies

null
    • szormpas
    • 1 yr ago
    • Reported - view

     Hi,

    Take a look at this post and see if it's what you're looking for.

      • gyannes
      • 1 yr ago
      • Reported - view

       

      • gyannes
      • 1 yr ago
      • Reported - view

       saw that post does not work for my setup. 

      • szormpas
      • 1 yr ago
      • Reported - view

        don't you ask for row numbering in a view element?

      • gyannes
      • 1 yr ago
      • Reported - view

       ok I inserted your code as follows.  And it worked for everything except if there is a duplicate the sequence numbers are out of synch. Notice in Gross there are two 82’s but GP (gross place) is 5,4 instead of 4,5.  Same happened for Net view for Net 73.

      The code i used follows the image

      let t := this;
      let arrayIDs := for loop1 in (select Players).Playsheet order by number(Players.Playsheet.Gross) do
              loop1.Id
          end;
      let i := 0;
      while item(arrayIDs, i) != t.Id do 
          i := i + 1
      end
      ;
      i + 1

      Additional info so I thought line 4 loop1.Id should be loop1.Players.Playsheet.Gross but then all values in GP become 1

      Then i tried to also t.Id in line 7 to the Gross field as well but Ninox locks up such that I can’t save the change.  I need to close the Ninox app and all changes are lost.

      • szormpas
      • 1 yr ago
      • Reported - view

        Hi,

      You're ascending on the gross and net columns, but I think you'll get the result you're looking for if you ascend on the GP and NP columns instead.

    • gyannes
    • 1 yr ago
    • Reported - view

    I read all the replies in that post and comments about using a select table could be an issue. I was hoping to see if anyone else had an option to try. 

    • Alain_Fontaine
    • 1 yr ago
    • Reported - view

    The necessity to use a "select" depends on the structure of your database.

    To add a row counter, in a context where a "select" is unavoidable, I use:

    let myt := Text;
cnt(select Table where Text < myt) + 1
    • szormpas
    • 1 yr ago
    • Reported - view

    Hi, just thought I'd let you know that you can also display an index column using the View Widget.

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 9Replies
  • 99Views
  • 4 Following