Log in to create and rate content, and to follow, bookmark, and share content with other members. Not a member? Join Now!

AnsweredAssumed Answered

Auto-correct position number in a portal

Question asked by tanja on Sep 17, 2018
Latest reply on Sep 18, 2018 by beverly

Like • Show 0 Likes0
Comment • 10

Hi,

I have a portal with entries in it. The addition of new entries was realized with a script: for every new entry, I jump to the last row of the portal. Row number minus 1 is my next position number! So far so good.

Now to my problem with 6 entries for instance:

If I delete the number 3 of the following entries

1. yellow

2. green

3. silver

4. white

5. black

6. blue

the new order should look like as following.

1. yellow

2. green

3. white

4. black

5. blue

but it looks like:

1. yellow

2. green

4. white

5. black

6. blue

How can I re-calculate the new position numbers?

Thanks

Tanja

No one else has this question

Outcomes

10 Replies

Jens Teich Sep 17, 2018 8:19 AM
Mark Correct
Correct Answer
Insert {{RecordNumber}} directly on the layout.
2 people found this helpful
Like • Show 2 Likes2
Actions
beverly Sep 17, 2018 9:08 AM
Mark Correct
Correct Answer
The SORT ORDER only needs to sortable (numerically or alphabetically). The "position" can change based on how it's sorted. You can display a "position" number that changes as the related records re-sort:
{{RecordNumber}}, as Jens says. This is the same as having an unstored calculation in that table:
Get ( RecordNumber )
Now, are you asking for a way to 're-sort' or add values (or remove values/related records) AND keep the numerical as always correct (dynamically). Or do you need to actually re-number your rows based on the sort?
Beverly
Like • Show 0 Likes0
Actions
philmodjunk Sep 17, 2018 9:44 AM
Mark Correct
Correct Answer
If you need the numbers to be actual data and a perfect sequence, it can be done as follows:

Use Go To Related Records to bring up a found set of these portal records in a different layout, if you make sure that no recors are open for editing on the current layout, (Use commit records if needed in your script), you can open this in a new window hidden "Off screen" from the user.

Use Replace Field Contents with the "serial number" option to perfectly renumber this set of records.

Close the window or return to original layout.

But note the comments by others, you may not need to do this at all.
Like • Show 0 Likes0
Actions
tanja @ beverly on Sep 17, 2018 11:08 AM
Mark Correct
Correct Answer
@Beverly,

yes, depending on the sort order. From 1..n when ascending and vice versa
Like • Show 0 Likes0
Actions
Tanner Sep 17, 2018 11:59 AM
Mark Correct
Correct Answer
for inspiration purposes:
Write a script and put it on the delete-button.

_________________________________________________________________________________________________________________________

#First: read number of Records in the Portal (relation) and store that info in a variable
Variable setzen [ $anzahlDS ; Wert: SQLAusführen ( "SELECT Count(*) from Tabelle_xy WHERE keyfield=?"; ""; ""; Any_ID_for_example ) ]
Variable setzen [ $counter ; Wert: 1 ]

#Then make a loop
Schleife (Anfang)
            Verlasse Schleife wenn [ $counter = $anzahlDS + 1 ]
            Gehe zu Ausschnittreihe [ Auswahl: Ein ; Mit Dialog: Aus ; $counter ]

                      # Now go to the field Position
                      Gehe zu Feld [ Tabelle_xy::Position ]
                      Feldwert setzen [Tabelle_xy::Position; $counter ]


            # Counter: increment
            Variable setzen [ $counter ; Wert: $counter+1 ]

Schleife (Ende)
.
.
.
<go on with other steps>
_________________________________________________________________________________________________________________________
Pay attention, that this works for ascending sort. May you set a trigger for "sorting" to renumber all fields with the same routine.
Hope that give you an idea.
BR

Tanner
Like • Show 0 Likes0
Actions
philmodjunk Sep 17, 2018 12:15 PM
Mark Correct
Correct Answer
With replace field contents, there is no need for a loop.
Like • Show 1 Like1
Actions
beverly @ tanja on Sep 17, 2018 12:41 PM
Mark Correct
Correct Answer
If you need this number (for other than sort), then the replace method works. You may wish to re-think the need for a 'set value' in a field when numbering by {{RecordNumber}}. I have found that the constant replace for this kind of value is unneeded.
Beverly
Like • Show 0 Likes0
Actions
tanja @ philmodjunk on Sep 18, 2018 1:31 PM
Mark Correct
Correct Answer
Hi,

sorry, but it does'nt work with the RecordNumber if I delete a row.
Like • Show 0 Likes0
Actions
philmodjunk Sep 18, 2018 2:20 PM
Mark Correct
Correct Answer
I didn't suggest using the record number. That was a suggestion by others.
Like • Show 0 Likes0
Actions
beverly @ tanja on Sep 18, 2018 2:57 PM
Mark Correct
Correct Answer
We suggested the {{RecordNumber}} for that very reason. Any addition or removal of a row won't matter. However, if you insist on the numbering being a field, then Phil's Replace Field Content must be done each and every time there is an addition or removal. If you don't worry about this needing to be a 'set value', you wouldn't need to script the replacement of it.
Beverly
Like • Show 0 Likes0
Actions

Auto-correct position number in a portal

Outcomes

Related Content

Recommended Content