This project called GFM Builder<\/em> is at prototype stage. It relies mainly on API wich are not documented, even if there are widely used in APEX export App files (before 22.1 version). This approach is clearly no supported, so this tool must be considered as a playground and used in a sandbox only. <\/p>\n\n\n\n The application GFM Builder is available from Github<\/a>. <\/p>\n\n\n\n Target audience<\/p>\n\n\n\n GFM Builder addresses mainly companies intranet requirements but citizen portals needs as well.<\/p>\n\n\n\n A common use case is to trigger an administrative process based on informations provided by an employee or a citizen. ie: renewal contrat, ordering internal good, signaling problem in a district, etc.<\/p>\n\n\n\n This tool will leverage, in a next version, the new approval task process which can be embeded in a page.<\/p>\n\n\n\n Once these limitations given, let’s see the functionnal aspects.<\/p>\n\n\n\n\n\n GFM Builder is dedicated to business users<\/em>. We consider the following roles:<\/p>\n\n\n\n The GFM Builder Role is implemented as a Contributor<\/em> Role in the APEX simplifed ACL model.<\/p>\n\n\n\n The GFM Builder Administrator role is maped on Admin<\/em> Role<\/p>\n\n\n\n In order to build a form, the GFM Builder Developer<\/strong> role must be granted to an APEX End user.<\/p>\n\n\n\n <\/p>\n\n\n\n Below are sample of forms generated with GFM Builder. <\/p>\n\n\n\n A form can embed a detail array for multivalued informations. In this case, it’s a historic of entries.<\/p>\n\n\n\n A sample catalog application (GFM Store) is provided as an exemple. Each time a form is tagged as Published<\/em>, it will be displayed in this catalog.<\/p>\n\n\n\n All data are stored in a unique table GFM_DATA.<\/p>\n\n\n\n The data can be displayed by GFM Builder Admin and Forms owners. <\/p>\n\n\n\n Final users will not be able to display data. We suppose that a process will send data to the user, by any feedback way, email for instance. It’s not in the scope of the project.<\/p>\n\n\n\n The design process is mainly declarative. It’s a matter of designing the items which constiture the form.<\/p>\n\n\n\n Instead of creating a data set then building the form (in in standard way), we create there both the data set and the form in the same user interface.<\/p>\n\n\n\n A form is comprised of items. An items is either a simple attribute (like text Field, date) or a multivalued attribute. This second kind of items is implemented as an Interactive Grid. This technical choice provides more flexibility during fields filling.<\/p>\n\n\n\n Items must be pick up from a predifined collection of components which are: <\/p>\n\n\n\n It’s possible to copy all items of an existing form into an other form. <\/p>\n\n\n\n <\/p>\n\n\n\n A section is a logical group of items which will be rendered as either a tab or a paragraph, depending a preference.<\/p>\n\n\n\n Fields are spreaded in sub-regions if there are two sections at least referenced by items. Navigation is provided by tabs, either with regular tabs or tabs and a first overall tab.<\/p>\n\n\n\n The user interface is very classic with very minimum usage of Drag n Drop. This is a weakness if we compare with other no-code tools on the market. But on an other hand, the tool priviliges flexibility in rendering, that is not the case with \u00ab\u00a0Google Forms\u00a0\u00bb, for instance. Rendering<\/p>\n\n\n\n <\/p>\n\n\n\n a set of preferences drives the generation process. We have reused APEX terminology in order to be in line with the regular Developer Interface.<\/p>\n\n\n\n For the moment, there are a few preferences:<\/p>\n\n\n\n <\/p>\n\n\n\n Below are some variants depending on \u00ab\u00a0Navigation between sections\u00a0\u00bb preference<\/p>\n\n\n\n <\/p>\n\n\n\n The creation of list of values is done by creating a new component with a LIST type. Then, a second page is used for entering the values. <\/p>\n\n\n\n An item can be displayed or not depending the value of an other item. If the driving item is based upon a List, the list of values will be proposed for choosing a specific value which will trigger displaying of slave item. <\/p>\n\n\n\n Implementation<\/p>\n\n\n\n The target application must belong to an arbitrary Application Group called ‘GFM Apps’ and must be choosed in the setup page. The ‘GFM Apps’ is automatically created during installation of GFM Store application.<\/p>\n\n\n\n List of Values<\/p>\n\n\n\n All the data are stored in a dedicated table: GFM_LOV.<\/p>\n\n\n\n Objects are named in Oracle database with GFM_<\/strong> prefix<\/p>\n\n\n\n If an item is renamed, there are no impact in the mapping<\/p>\n\n\n\n If an item is dropped, the mapped column in the GFM_DATA table is preserved, and no other item won’t be mapped on it. The reason it that we want avoid to display old data with the new item. Before form are deployed, they must by set \u00ab\u00a0Published\u00a0\u00bb state.<\/p>\n\n\n\n A form can be accessible either in a anonymous mode (no need to be authenticated) or in an authenticated mode.<\/p>\n\n\n\n because GFM Builder relies intensively on internal APEX API, some important flags have been set:<\/p>\n\n\n\n A compagnon Application called ‘GFM Store’ is provided as an example of an Apps store. <\/p>\n\n\n\n <\/p>\n\n\n\n APEX export API have been rewritten in 22.1 (wwv_flow_imp). That means that the previous API are not garanteed to be working in the future, and therefore neither is this tool GFM Builder.<\/p>\n\n\n\n Plugins used in the project<\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" Last revision: 27 sept 2022 The purpose of this project is to give to business users a no-code tool for generating forms. This project…<\/p>\n","protected":false},"author":1,"featured_media":5052,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"ppma_author":[150],"class_list":["post-4993","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-non-classe"],"authors":[{"term_id":150,"user_id":1,"is_guest":0,"slug":"admin8700","display_name":"Patrick","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/209d5ed69b74d288390621ab4c1d3773?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/4993","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/comments?post=4993"}],"version-history":[{"count":39,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/4993\/revisions"}],"predecessor-version":[{"id":5054,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/4993\/revisions\/5054"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/media\/5052"}],"wp:attachment":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/media?parent=4993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/categories?post=4993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/tags?post=4993"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/ppma_author?post=4993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}High level design<\/h2>\n\n\n\n
Persona and Role definitions<\/h3>\n\n\n\n
That means that we haven’t to declare users as APEX developers.<\/strong> Users will be able to author and publish forms without any knowledge of Oracle APEX. <\/p>\n\n\n\nGenerated Form Samples<\/h4>\n\n\n\n
![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-1-1024x559.png\")
![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-2-1024x549.png\")
Apps Store<\/h3>\n\n\n\n
![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-5-1024x562.png\")
<\/figure>\n\n\n\nData collecting<\/h3>\n\n\n\n
![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-14.png\")
Form design<\/h2>\n\n\n\n
Text,Number, Date, email, Inline List (List of values declared inline)
<\/li>
These lists are created in a dedicated page called ‘Components’, either by an administrator or the user himself.
<\/li>
It’a an existing form wich is declared as been usable as a grid inside an other form. ie: Historic of positions, list of contracts, etc.<\/li><\/ul>\n\n\n\n![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-17-1024x528.png\")
<\/figure>\n\n\n\nReusing existing form definitions<\/h4>\n\n\n\n
value and label are given the same value.<\/li>
per declaring the name of the external table or view.<\/li><\/ul>\n\n\n\nSections<\/h3>\n\n\n\n
![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-6-1024x577.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-16.png\")
User Interface<\/h2>\n\n\n\n
At the minimum, it’s possible by Drag’n Drop to re-order displayed items. <\/p>\n\n\n\n![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-3-1024x568.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-4-1024x566.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-7-1024x565.png\")
![\"This](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-8-1024x547.png\")
Generation options<\/h4>\n\n\n\n
![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-9-1024x571.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-10-1024x582.png\")
![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-11-1024x563.png\")
List of Values<\/h3>\n\n\n\n
![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-13-1024x499.png\")
![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-15-1024x435.png\")
Conditionnal displaying<\/h3>\n\n\n\n
Technical design<\/h2>\n\n\n\n
Data Model<\/h3>\n\n\n\n
![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/Form-Builder.png\")
<\/figure>\n\n\n\nGenerating process<\/h4>\n\n\n\n
Lifecycle<\/h3>\n\n\n\n
An option menu allow to reset data and column mapping. <\/p>\n\n\n\nSecurity<\/h3>\n\n\n\n
![\"\"](\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2022\/09\/image-12.png\")
<\/figure>\n\n\n\nAppendices<\/h2>\n\n\n\n
Non documented APIs used in this project<\/h3>\n\n\n\n