This topic is locked

Column width, etc

7/6/2020 10:12:30 PM
PHPRunner General questions
A
asawyer13 authorDevClub member

I see in v10 where I can allow the user to move columns, add and remove columns, and change widths of columns on a list page.
Please tell me there is some way I can get that information so I can save it by user and then restore it when the user comes back into that list.
Please, please.
Alan

S
sthefaine 7/7/2020

Alan,
I believe you will find this if you go to PAGES and click Settings next to List Page and choose Application Settings Table.

A
asawyer13 authorDevClub member 7/7/2020



Alan,
I believe you will find this if you go to PAGES and click Settings next to List Page and choose Application Settings Table.


I know how to set it up in PHPRunner so the user can do it. What I want to do is save that information off into a table so that when the user comes back to that list, I can show the same exact columns, in the order they wanted, and with the same exact columnn width.
So upon exit of the list I would save the values, then upon opening the list again, it would restore everything.
This is a game changer for me, so hopefully there is some way to do this.
Thanks

HJB 7/7/2020

In the Advanced grid mode, you can easily change the properties of labels, cells, and columns when you need to set specific formatting. If you don't change anything in advanced mode, the generated pages look the same as in the simple mode.

unquote excerpt ex https://xlinesoft.com/phprunner/docs/page_layout_grid_type.htm
Though not exactly of what you are looking for, it could be a workaround. Say, if MODIFIED to needs under ADVANCED GRID, a BUTTON shall appear on top of the table to call the modified to needs tabled content.

A
asawyer13 authorDevClub member 7/7/2020



In the Advanced grid mode, you can easily change the properties of labels, cells, and columns when you need to set specific formatting. If you don't change anything in advanced mode, the generated pages look the same as in the simple mode.

unquote excerpt ex https://xlinesoft.com/phprunner/docs/page_layout_grid_type.htm
Though not exactly of what you are looking for, it could be a workaround. Say, if MODIFIED to needs under ADVANCED GRID, a BUTTON shall appear on top of the table to call the modified to needs tabled content.


I would like the user at runtime to be able to move columns, hide columns, change width, and show columns.. This is all doable now in PHPR V10...
What I'm wanting to do is when the user leaves the list, I want to save all that info, column width, which columns are hidden/shown, and which columns are in which order, so that when that user comes back into that list a week from now, they will see the same exact columns, with the same width, and in the same order..
Is that making better sense?
In other words, another user could have that same list and show totally different columns, with different widths, etc.

HJB 7/7/2020

All functionalities seen with PHPR v10.4 are ending up by page(s) generation, made by the PHPR owner to be uploaded then. The page designer (usually the admin) is fixing how the content is to look like or as wished to be seen by the users. What you are looking for is to lay off the admin oriented design capabilities into the hands of the user which is web technically NOT possible, simply because any new page design needs to get uploaded to become visible. Simply speaking, coming by a question rather than an answer. Would you (as admin) render FTP oriented upload details (server password and connection details) into the hands of a user to enable same to upload his own wished page design? Certainly NOT.

A
asawyer13 authorDevClub member 7/7/2020



All functionalities seen with PHPR v10.4 are ending up by page(s) generation, made by the PHPR owner to be uploaded then. The page designer (usually the admin) is fixing how the content is to look like or as wished to be seen by the users. What you are looking for is to lay off the admin oriented design capabilities into the hands of the user which is web technically NOT possible, simply because any new page design needs to get uploaded to become visible. Simply speaking, coming by a question rather than based upload an answer. Would you (as admin) render FTP oriented upload details (server password and connection details) into the hands of a user to enable same to run his own wished design done and finally uploaded unto the server via FTP ? Certainly NOT.


That's not what I'm wanting to do.. Right now the user can at runtime, change the columns he/she see but showing or hiding, change the column widths, and change the column order.
All I'm wanting to be able to do is save that information somehow and use it later restore it back to look the same for that user.
I'm not wanting the user to do any changes in the design, other than what I described and that capability already exists in the generated application.

W
WilliamBDevClub member 7/7/2020



That's not what I'm wanting to do.. Right now the user can at runtime, change the columns he/she see but showing or hiding, change the column widths, and change the column order.
All I'm wanting to be able to do is save that information somehow and use it later restore it back to look the same for that user.
I'm not wanting the user to do any changes in the design, other than what I described and that capability already exists in the generated application.


The settings are saved to a DB table that you pick or allow PHPRunner to create for you. When you chose to turn this feature on the table is clearly displayed on that screen. Also the settings are saved and when that user goes to that list page their settings are displayed.
Billy

A
asawyer13 authorDevClub member 7/7/2020



The settings are saved to a DB table that you pick or allow PHPRunner to create for you. When you chose to turn this feature on the table is clearly displayed on that screen. Also the settings are saved and when that user goes to that list page their settings are displayed.
Billy


Billy, I sure didn't see the table name but I'll look again.
That will get me very close to what I'm ultimately wanting. Do you think there is anyway that programmatically I can load and save the values instead of PHPRunner doing it automatically? The reason I am asking is that in a perfect world, I could allow to user to save the layouts by name, and then later retrieve and load them by name. That would be extremely powerful.
Thanks

Alan

A
asawyer13 authorDevClub member 7/7/2020



Billy, I sure didn't see the table name but I'll look again.
That will get me very close to what I'm ultimately wanting. Do you think there is anyway that programmatically I can load and save the values instead of PHPRunner doing it automatically? The reason I am asking is that in a perfect world, I could allow to user to save the layouts by name, and then later retrieve and load them by name. That would be extremely powerful.
Thanks

Alan


Maybe I can manipulate the data in the table to accomplish what I'm wanting to do. I will do more research once I check out the table.
Alan

A
asawyer13 authorDevClub member 7/7/2020



Maybe I can manipulate the data in the table to accomplish what I'm wanting to do. I will do more research once I check out the table.
Alan


I didn't even see the table name there on the page. Glanced right by it. I wonder timing wise if there is any way I could manipulate the table data right after it's saved it and right before it's loaded it.. That would be perfect if I could.
Alan

S
salus1DevClub member 7/7/2020

The List Page Settings dialog lets you create an application settings table so...
"You can select the table to store the application settings like the order of columns, show/hide states, column sizes, and saved searches. These settings are user-specific."