/* * Author : totodalus * Generated on : 26-Nov-2017 09:26:47 * Version : 1.0 */ application "FORM REKAP HARGA Px 8400-1" { date format = "dd-MMM-yyyy" time zone = "Asia/Jakarta" section Section_1 { displayname = "Sheet1 (5)" list Sheet1_5_View { displayName = "Sheet1 (5) View" show all rows from Sheet1_5 ( PRODUK TOTALISATOR SINGLE_LINE PENJUALAN RUPIAH ) } list Sheet1_5_Report { displayName = "Sheet1 (5) Report" show all rows from Sheet1_5 ( PRODUK TOTALISATOR SINGLE_LINE PENJUALAN RUPIAH ) conditional formatting ( "New Formatting" { fields = [TOTALISATOR] format = "background-color:#ffff00;" } "New Formatting" { fields = [SINGLE_LINE] format = "background-color:#ffff00;" } ) } form Sheet1_5 { displayname = "Sheet1 (5)" success message = "Data Added Successfully!" field alignment = left PRODUK ( type = text width = 300px ) TOTALISATOR ( type = text width = 300px ) SINGLE_LINE ( type = text width = 300px ) PENJUALAN ( type = text width = 300px ) RUPIAH ( type = text width = 300px ) actions { on add { submit ( type = submit displayname = "Submit" ) reset ( type = reset displayname = "Reset" ) } on edit { update ( type = submit displayname = "Update" ) cancel ( type = cancel displayname = "Cancel" ) } } } list Sheet1_5__1_View { displayName = "Sheet1 (5)_1 View" show all rows from Sheet1_5__1 ( PERTALITE_A as "PERTALITE A" NUMBER as "5708799" SINGLE_LINE as "5710323" NUMBER1 as "1524" NUMBER2 as "11430000" ) } list Sheet1_5__1_Report { displayName = "Sheet1 (5)_1 Report" show all rows from Sheet1_5__1 ( PERTALITE_A as "PERTALITE A" NUMBER as "5708799" SINGLE_LINE as "5710323" NUMBER1 as "1524" NUMBER2 as "11430000" ) conditional formatting ( "New Formatting" { fields = [NUMBER] format = "background-color:#ffff00;" } "New Formatting" { fields = [SINGLE_LINE] format = "font-weight:bold;" } "New Formatting" { fields = [NUMBER1] format = "font-weight:bold;" } "New Formatting" { fields = [NUMBER2] format = "font-weight:bold;" } ) } form Sheet1_5__1 { displayname = "Sheet1 (5)_1" success message = "Data Added Successfully!" field alignment = left PERTALITE_A ( type = text displayname = "PERTALITE A" width = 300px ) NUMBER ( type = number displayname = "5708799" width = 300px ) SINGLE_LINE ( type = text displayname = "5710323" width = 300px ) NUMBER1 ( type = number displayname = "1524" width = 300px ) NUMBER2 ( type = formula displayname = "11430000" value = input.NUMBER1 * 7500 visibility = true width = 300px ) actions { on add { submit ( type = submit displayname = "Submit" ) reset ( type = reset displayname = "Reset" ) } on edit { update ( type = submit displayname = "Update" ) cancel ( type = cancel displayname = "Cancel" ) } } } list Sheet1_5__2_View { displayName = "Sheet1 (5)_2 View" show all rows from Sheet1_5__2 ( PREMIUM SINGLE_LINE as "8011675" SINGLE_LINE1 as "8013002" AUTO_NUMBER as "1327" AUTO_NUMBER1 as "8691850" ) } list Sheet1_5__2_Report { displayName = "Sheet1 (5)_2 Report" show all rows from Sheet1_5__2 ( PREMIUM SINGLE_LINE as "8011675" SINGLE_LINE1 as "8013002" AUTO_NUMBER as "1327" AUTO_NUMBER1 as "8691850" ) conditional formatting ( "New Formatting" { fields = [SINGLE_LINE1] format = "font-weight:bold;" } "New Formatting" { fields = [AUTO_NUMBER] format = "font-weight:bold;" } "New Formatting" { fields = [AUTO_NUMBER1] format = "font-weight:bold;" } ) } form Sheet1_5__2 { displayname = "Sheet1 (5)_2" success message = "Data Added Successfully!" field alignment = left PREMIUM ( type = text width = 300px ) SINGLE_LINE ( type = text displayname = "8011675" width = 300px ) SINGLE_LINE1 ( type = text displayname = "8013002" initial value = "TOTAL" width = 300px ) AUTO_NUMBER ( type = autonumber displayname = "1327" start index = 1327 width = 300px ) AUTO_NUMBER1 ( type = autonumber displayname = "8691850" start index = 8691850 width = 300px ) actions { on add { submit ( type = submit displayname = "Submit" ) reset ( type = reset displayname = "Reset" ) } on edit { update ( type = submit displayname = "Update" ) cancel ( type = cancel displayname = "Cancel" ) } } } list Sheet1_5__3_View { displayName = "Sheet1 (5)_3 View" show all rows from Sheet1_5__3 ( BIO_SOLAR_A as "BIO SOLAR A" NUMBER as "7807883" SINGLE_LINE as "7808285" NUMBER1 as "402" NUMBER2 as "2070300" ) } list Sheet1_5__3_Report { displayName = "Sheet1 (5)_3 Report" show all rows from Sheet1_5__3 ( BIO_SOLAR_A as "BIO SOLAR A" NUMBER as "7807883" SINGLE_LINE as "7808285" NUMBER1 as "402" NUMBER2 as "2070300" ) conditional formatting ( "New Formatting" { fields = [NUMBER] format = "background-color:#ffff00;" } "New Formatting" { fields = [SINGLE_LINE] format = "font-weight:bold;" } "New Formatting" { fields = [NUMBER1] format = "font-weight:bold;" } "New Formatting" { fields = [NUMBER2] format = "font-weight:bold;" } ) } form Sheet1_5__3 { displayname = "Sheet1 (5)_3" success message = "Data Added Successfully!" field alignment = left BIO_SOLAR_A ( type = picklist displayname = "BIO SOLAR A" values = {"", "BIO SOLAR B"} width = 300px ) NUMBER ( type = number displayname = "7807883" width = 300px ) SINGLE_LINE ( type = text displayname = "7808285" width = 300px ) NUMBER1 ( type = number displayname = "402" width = 300px ) NUMBER2 ( type = formula displayname = "2070300" value = input.NUMBER1 * 5150 visibility = true width = 300px ) actions { on add { submit ( type = submit displayname = "Submit" ) reset ( type = reset displayname = "Reset" ) } on edit { update ( type = submit displayname = "Update" ) cancel ( type = cancel displayname = "Cancel" ) } } } list Sheet1_5__4_View { displayName = "Sheet1 (5)_4 View" show all rows from Sheet1_5__4 ( DEXLITE SINGLE_LINE as "5865065" SINGLE_LINE1 as "5865158" AUTO_NUMBER as "93" AUTO_NUMBER1 as "678900" ) } list Sheet1_5__4_Report { displayName = "Sheet1 (5)_4 Report" show all rows from Sheet1_5__4 ( DEXLITE SINGLE_LINE as "5865065" SINGLE_LINE1 as "5865158" AUTO_NUMBER as "93" AUTO_NUMBER1 as "678900" ) conditional formatting ( "New Formatting" { fields = [SINGLE_LINE1] format = "font-weight:bold;" } "New Formatting" { fields = [AUTO_NUMBER] format = "font-weight:bold;" } "New Formatting" { fields = [AUTO_NUMBER1] format = "font-weight:bold;" } ) } form Sheet1_5__4 { displayname = "Sheet1 (5)_4" success message = "Data Added Successfully!" field alignment = left DEXLITE ( type = text width = 300px ) SINGLE_LINE ( type = text displayname = "5865065" width = 300px ) SINGLE_LINE1 ( type = text displayname = "5865158" initial value = "TOTAL" width = 300px ) AUTO_NUMBER ( type = autonumber displayname = "93" start index = 93 width = 300px ) AUTO_NUMBER1 ( type = autonumber displayname = "678900" start index = 678900 width = 300px ) actions { on add { submit ( type = submit displayname = "Submit" ) reset ( type = reset displayname = "Reset" ) } on edit { update ( type = submit displayname = "Update" ) cancel ( type = cancel displayname = "Cancel" ) } } } list Sheet1_5__5_View { displayName = "Sheet1 (5)_5 View" show all rows from Sheet1_5__5 ( TOTAL_LITER as "TOTAL LITER" AUTO_NUMBER as "9763" ) } list Sheet1_5__5_Report { displayName = "Sheet1 (5)_5 Report" show all rows from Sheet1_5__5 ( TOTAL_LITER as "TOTAL LITER" AUTO_NUMBER as "9763" ) conditional formatting ( "New Formatting" { fields = [TOTAL_LITER] format = "font-weight:bold;font-style:italic;color:#00b050;" } "New Formatting" { fields = [AUTO_NUMBER] format = "font-weight:bold;font-style:italic;" } ) } form Sheet1_5__5 { displayname = "Sheet1 (5)_5" success message = "Data Added Successfully!" field alignment = left TOTAL_LITER ( type = text displayname = "TOTAL LITER" initial value = "GRAND TOTAL" width = 300px ) AUTO_NUMBER ( type = autonumber displayname = "9763" start index = 65812750 width = 300px ) actions { on add { submit ( type = submit displayname = "Submit" ) reset ( type = reset displayname = "Reset" ) } on edit { update ( type = submit displayname = "Update" ) cancel ( type = cancel displayname = "Cancel" ) } } } } customize { layout = "tab" color = "black" base theme = "professional" new theme = 1 icons = true } share_settings { "Administrator" { name = "Administrator" type = Users_Permissions permissions = {Chat:true, Predefined:true} description = "This profile will have all the permissions.\n" } "User" { name = "User" type = Users_Permissions permissions = {Chat:false, Predefined:false} description = "This profile only have add and view permission.\n" ModulePermissions { Sheet1_5__4 { enabled= Create,Viewall,Tab,View,Search FieldPermissions { AUTO_NUMBER{visibility:true,readonly:false} SINGLE_LINE{visibility:true,readonly:false} SINGLE_LINE1{visibility:true,readonly:false} DEXLITE{visibility:true,readonly:false} AUTO_NUMBER1{visibility:true,readonly:false} } } Sheet1_5__5 { enabled= Create,Viewall,Tab,View,Search FieldPermissions { AUTO_NUMBER{visibility:true,readonly:false} TOTAL_LITER{visibility:true,readonly:false} } } Sheet1_5__2 { enabled= Create,Viewall,Tab,View,Search FieldPermissions { AUTO_NUMBER{visibility:true,readonly:false} SINGLE_LINE{visibility:true,readonly:false} SINGLE_LINE1{visibility:true,readonly:false} PREMIUM{visibility:true,readonly:false} AUTO_NUMBER1{visibility:true,readonly:false} } } Sheet1_5__3 { enabled= Create,Viewall,Tab,View,Search FieldPermissions { SINGLE_LINE{visibility:true,readonly:false} NUMBER{visibility:true,readonly:false} BIO_SOLAR_A{visibility:true,readonly:false} NUMBER1{visibility:true,readonly:false} NUMBER2{visibility:true,readonly:false} } } Sheet1_5 { enabled= Create,Viewall,Tab,View,Search FieldPermissions { PENJUALAN{visibility:true,readonly:false} PRODUK{visibility:true,readonly:false} SINGLE_LINE{visibility:true,readonly:false} RUPIAH{visibility:true,readonly:false} TOTALISATOR{visibility:true,readonly:false} } } Sheet1_5__1 { enabled= Create,Viewall,Tab,View,Search FieldPermissions { PERTALITE_A{visibility:true,readonly:false} SINGLE_LINE{visibility:true,readonly:false} NUMBER{visibility:true,readonly:false} NUMBER1{visibility:true,readonly:false} NUMBER2{visibility:true,readonly:false} } } } } } }