A Few New User Questions

[jsandberg]

Hi all,

I am VERY new to this application and need a few questions answered. I appreciate anyone's input.

1. I have a button that I created to toogle between my list layout and my form layout. There is a separate button on each page. The button on the list page works and will transfer me to my form layout when I push it howver will not work from form to list. What am I doing wrong?

2. How do I set up my columns in the list layout the be sortable by clicking the heading at the top of each column? I see that in some of the pre-made solutions there is this feature and I can not figure out how to replicate.

3. Is there a way to make the orientation different for page set up for my list layout vs my form layout? I want the list to print landscape and the form to print portait.

4.Is there a free icon place where I can download an icon for Show All Records?

5. Is there a way to set and make static the sort box? It sticks for a while and then when I come back there are other sort features listed that I do not even have as fields. How do I make them stay put until I change them?

6. For my Show All Records button, can someone help me to write a sort script so that once al of the records are displayed, they are custom sorted as I set it up?

Thanks for your help!

[Lee Smith]

Hi J, and welcome to the forum.

Most of this post is dealing with the differences between the view.

The Table View is a relative new comer, having arrived with the release of version 6 (if I recall correctly), and it was mainly to provide an Excel spreadsheet look.

For the button to work, you need to add a Header Part, using the Layout Setup option in Layout Mode, and then put your button on it.

To sort a Table View, is an option in the same menu as the adding a part.

Take a look at the options in the Script Step Print and Page Setup.

There are free icons, and I believe there are some files in the Sample File Area, and suggestions, and links in the Right Brain Topic Area.

Not sure what you mean by the Stay put Sort Box?

The desired script can be accomplished using the Show All Script Step.

HTH

Lee

[jsandberg]

Hi,

I have another question. In my List View, when I click on New Record, it always inserts it as the second row, after the first row. How do I get it to insert on the very top row?

Thanks!

[Lee Smith]

Hi again,

Is this the active recored when you change from one view to another, if so, then it is working proper. If not, then you need to give us more detail about what you are doing.

Lee

[jsandberg]

I have another area that I need guidance on. I am trying to create a custom report. I have a field that is a drop down menu with 5 choices. For my report I only want to include 1 of the 5 choices and omit all of the other 4. Please let me know how I can do this. A zillion thank yous for the guidance.

[m.v.peabody]

Try creating a new layout for the report, and force the option you want, perhaps with a different field using auto-enter.