MS4BIĀ®

MS4BI HELP 2022

by MS4script
01-Introduction
Preface & Copyright
Getting started
Informations + Cmd/param Server
Demos Simple
02- Declarations
Structure
Type
03- Instructions
Conditions if,do,while..
String functions Str..()
Get + Include functions Get, Include..
Date-Time Day, Time, Year.
Display
Call
Formulas Complex
04- Database
Connector Ado, Odbc, Dsn, SAP, Ms4
DB Connect Create, delete
Import DataSource Import, Consolidation
Administration Admin, User
05- Sql-Query
Sql
Query Form : BTS,PLUS
Grid option
06- Charts
Forms Plus, Win, Image, Excel, Morris...
Pie Std, Donut, 3D...
Bar Std, Stack, Line, Area, Plot
Radar
QrCode, Gauge
Step, Stock...
,Google,Leaflet... GeoMap
,Gantt,Timeline,Org.
DrawWindow [web]
07- Dashboard
Form tab, no tab
Responsive UI
08- Report
Report Hierarchy
Report Design
09- Filters
Dialogue + Call
10- Menus
Menu Design
Menu Frameset
Menu Custom
11-UI : Responsive
Tables Responsive,Frame,position
List Group
Text
Panel Header, body, Footer
Button Button, Progress Bar
Icon & Button
Collapse Group, Panel
Notifications
12- Encryption
Encrypt
Decrypt
13- Windows
Dialogue
Picture, Frame, Button..
MsgBox
Grid

Designer

00-OverView
01-Transaction
02-Setting
05-Import
10-Formula
15-Report-Part1
16-Report-Part2
20-Query-Part1
21-Query-Part2
25-Report-Query-Style
30-QrCodeImage
31-Windows
32-Frame
40-TabStrip
50-Collapse
60-BeginForm
63-Input-SubmitBox
70-Input-Select
71-Input-Insert
72-Input-Update
73-Input-Delete
75-Input-Query
77-ListComBo
81-Button-Link
82-Button-DataList
86-Sticky-Label
91-Insert-PhpJsHtml
92-Insert-MS4script
15- Css, html, Php, js.
Insert Native language Begin_sw..End_Sw
16-Install + tools.
Installation & Configuration This Menu
Generate Native... Php, Html, js..
Code Generator Ms4 Script
MarkDown Ms4 Script
Source Code Menu Help This Menu
written with ms4script
MS4BI
     

BASIC HELP : MS4BI Designer by MS4script

2021 version 1


FORM (input)



KEYWORD :
BEGIN_FORM inputdata,Inputselect...Submit()... END_FORM

  	
Begin_transaction ; nameTRS  
  cycle : insert table xxxx, update table xzzzzn delete Row table xx.. 
  begin_form  
   input var1 ..Input var2..submit
   End_form ; 
       Chart or dashboard or image or grid....
  End_transaction ;  

Demarche & Option Setting


  • 1 - Dessiner les variables : input Data ou select
  • 2 - Choisir l'option 1 Setting pour determiner les cycles : INSERT OU UPDATE t/ou DELETE
  • 3 - Ajouter un boutton : Submit
  • voir le help : setting

  • Process

    Example 1

      	   
     Begin_TransactionWeb : "02-DataEditADD" , 
        Cycle :  
       Insert :  table "Family"  
       Delete : table "Family" ;  
      

    Begin_FormWeb ** INSERT

       position:367,367,38,119 :
    <InputSelect : type="int" name="MONTH" like : table("Family") class=standardMs4 placeholder="please select-MONTH-" >;    position:369,498,auto,auto :
    < button + GetSelectPop() : $Bts_btn_success_btn_sm , icon : $fa_1x + $fa_search , text : "Select" > ;    position:426,370,35,114 :
    <InputSelect: type="int" name="YEAR" like : table("Family") class=standardMs4 placeholder="please select-YEAR-" >;    position:428,496,auto,auto :
    <button + GetSelectPop() : $Bts_btn_success_btn_sm , icon : $fa_1x + $fa_search , text : "Select" > ;    position:559,365,33,125 :
    <InputData : type="real" name="PROJECTED" like : table("Family") class=standardMs4 placeholder="-0-" >;    position:629,367,36,120 :
    <InputData: type="real" name="ACTUAL" like : table("Family") class=standardMs4 placeholder="-ACTUAL-" >;    position:612,537,74,144 :
    <InputData: type=SubmitForm() class="btn btn-lg btn-primary" attrib="value='Submit (ADD)' " >;   

    End_FormWeb ;

      

    Begin_FormWeb ** DELETE

       position : 631,691,48,116:
    <button + SetDeleteRow("Family" ) : $Bts_btn_info_btn_sm , icon : $fa_1x + $fa_eraser , text : "Submit (Delete)" > ;   

    End_FormWeb ;

       ....

    Interested in joining us?? contact@mgplanete.com
    The Mg Planete team

    the official sites :
    www.mgplanete.com
    getms4bi.com
    demos.ms4bi.com
    help.ms4bi.com
    www.ms4script.com