Menu

2/3: Have multiple forms per table.

+3 votes

Having only one form per table is too limiting. For this tool to work for me (and to compete with Airtable, for example) I need to have the ability to view table data in several formats depending on the need. Moreover, it would be good to be able to set user credentials allowing access to all or some of these multiple forms.

A way to achieve this without too much programming it would seem is to simply allow tables to be duplicated in the Manage Table lists while giving an opportunity to assign a caption or alias to these duplicated tables.

Also, while I'm a very new user of dbFront, there doesn't appear to be a way to save common filters or filter on a prompted value. Moved to: Saved Filters and Sorting

in Features (Todo) by (210 points)
edited by
Part of your request is a duplicate of another feature request.  Please vote for: https://dbfront.com/qa/319/control-table-visibility-through-ad-security-groups
Moved and added a link to your other request explaining the filtering request.

3 Answers

0 votes

Solution #1: Create a separate database connection and in this way create a completely separate application with completely different security, form layouts and reports.

This solution is appropriate if you are serving different departments (HR vs Finance) or completely different user classes. e.g. Internal users vs Public users vs Vendors.

This is also the most secure solution since you can use database security to ensure that each user group can't possibly bypass dbFront security to access more than they should.

by (50.7k points)
Is it possible to copy an existing database connection?
That question is too big for a comment.  Please ask it as a related question.  Do you want to copy the connection and the configuration or only the connection?
Both, potentially. If the workaround for this question is to create separate connections, just trying to see if there's anything I can do to make the process easier. I'll ask it as a related question.
There is no automatic way to duplicate a connection and all of its configuration.  What you can do is: 1) Create a new connection manually using the same security so that the same database objects are available. 2) Export and then Reimport the database configuration from the source connection to the destination configuration.  Note: Please use the latest dbFront version (1.1.1.3232 or better) as it is most reliable.
0 votes

Solution #2: Use Visibility Conditions to hide or show different parts of the Form as needed.

This solution is appropriate if the purpose is to have the form layout respond to the current record's status.

As of version 1.0.11.0389, dbFront has the ability to hide and show field groups in addition to the ability to manage button visibility. This can be used to hide or show fields based on the contents of the current record or any data reachable via a joined view.

As of version 1.1.1.3232, you can now hide or show fields and buttons based upon the current %username%.

by (50.7k points)
edited by
0 votes

Having multiple form layouts per table within a single application is interesting and I have had other requests for this feature.

The biggest question to consider is how deep the configuration duplication goes and how much configuration would be shared between the forms.

NOTE: Please vote on this Feature Request and this Answer if the other proposed solutions are not enough. Please also provide a use-case in the comments so that I can understand what your are trying to accomplish.

by (50.7k points)
edited by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...