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

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

Recommended Posts

Posted

I cannot find the straight answer and this seems very rudimentary... sorry. I just cannot seem to get it right.

I have a table called Users with a layout of user information. There are approximately 200 records in this table. I want to create a new layout that has the entire list of students in rows. The purpose of this is to create a "Quick Link" to user information in the other layout.

I was thinking portal - but it seemed to me that I need to get the list into a repeating field and use the (show range)to decide how many would be in each column. I created a self join UserID as the key field and then I am stuck.

Help on this one?

Posted

Do "users" = "students"?

If so, all you need is a list view layout based on the same table. Then, put a button in the body part of the list view that does Go to Layout "MyFormLayout".

Posted

Do "users" = "students"?

If so, all you need is a list view layout based on the same table. Then, put a button in the body part of the list view that does Go to Layout "MyFormLayout".

Sorry.. A confusing post with missing details. I have a table called users. Within the table I have a field called firstLast. The is the first and last name of the user. I was hoping to view these records in columns and rows... Say one layout with 8 columns and 25 rows (with only the firstLast field). I understand about the list view, just confused on the rows/columns layout... While at the same time, keeping the field as a clickable button.

Posted

A repeating field shows multiple values in a single record. You want to see multiple records - meaning either a list view or a portal. You can place 8 portals, each 25 rows tall, side by side and set the initial row to 1, 26, 51, etc.

I created a self join UserID as the key field

If you want to show all records in the table, use the x relational operator.

I am not sure what you'll do if the number of users exceeds 200.

Posted

The portal will work fine for now. I will not have more than 200 users. I have the field firstLast in the portal and set the portal to show specific rows. Thanks for the help... just one more thing. I have this firstLast field in the portal set as a button so that it displays student info in a new window when clicked... However, I need it to go to the related student info in a new window. Cannot get this to work in the portal, but could in list view. It just goes to the first record, ideas?

This topic is 4903 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.