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..
Char/Text functions Char or Text..()
Get + Include functions Get, Include..
String functions String# (hashtag)
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

IMPORT = 1 table

Overview : 3 STEPS

Parameters + File
  • Enter your Database Name
  • Enter your Table Name
  • STEP 1 : Select your Excel or Csv File + Sheet Name+$
  • STEP 2 : Import
  • STEP 3 : Update Fields (name,type) with View Database

    • Example

    Step 1 : Parameters + Excel File

    Parameters + File
  • Enter your 99-test.db
  • Enter your Table1
  • STEP 1 : Select your Excel or Csv File + people$

    • Example

    Step 2 : Import + Confirmation + List View Table

    Import File
  • STEP 2 :
  • Import
  • Confirmation
  • List View Table + field

    • Example

    Step 3 : Database ( optional)

    DataBase
  • STEP 3 :
  • Database
  • Update :
  • field + type + index etc..

    • RESET

    RESET
  • RESET :
  • RESET Database : not Delete imports (others tables)
  • RESET Database & Import : Delete ALL : DB + imports

    • 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