Dynamic Table columns

[xtrim]

Hi

Is there a way to let a user choose what he wants to see in a table and what not? (dynamicaly, not to create a layout for each possible set fo fields...)

Is it possible in a portal?

Is it possible to save these settings for each user? (including the order of the columns)

[Ender]

You can do this with the GetField() function.

[xtrim]

Hi

You mean in a regular table ? in a portal?

Is it possible to save these settings for each user?

do you have an example?

Could you be a bit more specific?

[Ender]

In the attached example, I show how to use getfield() to allow users to dynamically choose portal fields (for display) and report fields for a print report. You can also sort the report or portal dynamically by choosing fields to sort by.

The example is set up for the default Admin account, but it should keep track of each user's choices if you add additional accounts.

DynamicReport.fp7.zip

[xtrim]

Hi !! That is great trick...

Tnx again

I don't know what I would have done without this forum....

[xtrim]

I've modified it a bit to support also sort direction...

If you don't mind... I would like to put it also in the portal forum (ofcoure you get the full credit ;-) )

DynamicPortalColumnAndSort.zip

[Lee Smith]

I am deleting your Cross Post.

If Ender wants to share his file on a broader note, then he should submit it as a sample file, to the "[color:"blue"]Solutions & Suggestions >> Sample Files & Open Source Solutions ", including any descriptive comments. That's why this area exist.

In the mean time, just refer others to this Thread when you think it will help them with a similar problem.

HTH

Lee

[xtrim]

Hi

I tried also (for fun) to make dynamic Value lists to each dynamic field,

meaning - if I change a column, then I get a different VL on that field.

I played with it, and I can't index the field that stored the VL, thus I can't make it a VL...

( I don't want to use "getfield(field)" , because it wont change unless record is updated...)

any suggestion?

[xtrim]

?