Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Simple Portal Row Numbering?


This topic is 7448 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hi all:

I had thought this would be very simple, but once I realized I'd never done it before, I just ran into a mental wall. Instead of beating my head against that wall, I've moved on to the next problem and am posting the question here:

I just want each row in a portal to show an item number, starting from 1 and going to how ever many rows are currently being shown in the portal. This is a formatting issue requested by the client, like this:

1. (Item description, Item price)

2. (Item description, Item price)

3. (Item description, Item price)

etc., but if there's only 3 items showing in a six-row portal, I want the numbers to stop at 3.

It's really simple, right? So what's the easy answer?

Thanks in advance,

-Stanley

Posted

Put @@ in the first row of your portal. It's the symbol for current record number.

Posted

Man, you guys are fast. I knew it would be simple.

Thanks

-Stanley

Posted

is there a way to run the numbers abckwards? ie. i have a portal whose records are sorted by date, with the oldest records at the bottom of the portal and the newest ones at the top. this way i can see the most recent activity without scrolling to the bottom of the portal. i'd like to number them this way as well. any ideas?

Posted

May be through the ValueListItems( ) function.

Create a Value List of Record_IDs involving your Portal Relationship.

Use the sorted by second value option, and pick the 'DateField'.

Now :

c_VLI = ValueListItems(Status(CurrentFileName),"IDsListSorted")

and

Patterncount(c_VLI,"

  • 3 months later...
  • 2 months later...
Posted

is there a simple way to then get the @@ to appear on a report from the data in the portal?

Ric

This topic is 7448 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.