Jump to content
Sign in to follow this  
Jarvis

Transposing Table View

Recommended Posts

In MS Excel there is a simple command to transpose data.

To do this you copy a row of values then perform a process called "paste special > transpose". Anything that was a row becomes a column and anything that was a column becomes a row.

Is there a way to do something like this in table view?

What I would like to have is my fields arrayed in column format

with all the record values distributed horizontally across the page like a spreadsheet.

In this example the text "CUT DOORS" etc would be a field name

and the text A:B:C would be values for each record.

This would give me a graphical spreadsheet to monitor production status.

Any ideas how to do this?

Thanks,

Jarvis

checklist.JPG

Share this post


Link to post
Share on other sites

I know what you mean. I have long wished for the ability to create "horizontal" portals for the same reason. It would be nice to be able to display records horizontally rather than vertically in the table or list views was well.

If your business plan doesn't change much you can display the data horizontally by creating a relationship for each "column" of data and displaying it as a portal. I've even resorted displaying a 10x10 grid by defining a relationship for each square in the grid... it does not make a pretty relationship graph.

Share this post


Link to post
Share on other sites

Thank you John.

This may indeed be what I am looking for.

I will need to stare at it a bit longer to be sure.

Jarvis

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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