Further Market
  • Essentials

    • Foreword
    • What is FM Script ?
    • The philosophy and benefits of FmScript
    • What you will learn
  • Recall

    • Internet: who? what? What is that?
    • Further market and FMScript
    • The compiler
  • Download
  • Getting started

    • Installation
    • Create a business account
    • Connect to the PC application
    • Create your first applet
    • Create your first web applet
    • Compiler view
  • Basics

    • basic rules
    • Reserved keywords
    • The Syntax
    • Coding Style
    • comments
    • Variables, constants, and data types
    • Convertion of types
    • Conditions and loops
  • Functions

    • Create a Menu
    • Create input field (Input2)
    • Create a QR Code
    • Scan a QR Code
    • Strings functions
    • Array functions
    • Date Time functions
    • Mathematics functions
    • JSON functions
    • XML functions
    • Call Http request
    • Manipulate Sessions
    • Financial functions
    • Notifications
    • Bleutooth Printer
  • Demos

    • Advanced Inputs
    • Call http Request
    • loops and conditions
    • Menu inputs
    • Array items count
    • Simpe for
    • simple select count Sql Query
    • Date and Time picker form
    • Get credit balance
    • is valid city
    • user info from phone number
    • get country and city from form
    • simple ussd link switch
    • charge user credit
    • simple message box
    • user entry code
    • get users relations
    • my external payements collected
    • call google Map
    • in App direct publish
    • Geo location
    • Charts
    • menu with hints
    • call system Messenger
    • user start code
    • In call Gallery
    • credit card payment Request
    • MTN CMR Airtime Product Subscription
    • MenuItemAddContacts
    • AJax and FM Input
    • Input2
    • MenuItemAddRichMedias
    • MenuItemAddTagsItems2
    • BlinBlin Menu + javascript
    • GENERAL ALERT MESSAGE WITH JSON OPTIONS
    • Barcode
  • databases

    • CRM
    • External Payments
    • Bills
    • Sales
    • Games
    • Applets
    • Payments Gateway
    • Manipulate Select Queries
  • APIs

    • Further Markey Pay button integration
    • Mobile Money cash collector
    • Bill Api
    • API PUBLISH PRODUCT
    • Sale Api
    • SMS Api
  • Advanced

    • Actions scheduler
    • Events settings
  • USSD CAMEROON

DATABASE WITH CRM

  • Explanation
  • create CRM file
  • CRM_Select
  • CRM_Insert
  • CRM_Update
  • CRM_Delete

 

Explanation

CRM (Customer Relationship Management) is a simple mechanism for storing data in a restricted space on Further Market. To use a CRM file, you must create it, retrieve its ID ( FileID ), and provision it by setting CRM functions at the specified time.

 

create CRM file

So let's see step by step how to create a CRM file.
1) First, you have to be connected on your Business account into Further Market desktop app. Then click on the Business tab as you see below!


2) So when you click on Business tab, you have a new interface, now you can click on "Database Tables" as you see below. You may notice that i have two tables into my Database Tables. Don't worry, we'll create a new table soon. Click on "Add" button.


3) Afther you clicked on "Add" button, you have new interface as below. Fill name and description field, and then click on "Save" button.


4) When you save it, you notice that your table have been added into Database.


5) Now you may double click on your table, you'll have a list of CRM files for this table. For the moment, this list is empty. Click on \"new\" button placed down to this view and new interface will appear.


6) Now you can fill fields as below!, then click on "validate" button



7) Now your CRM file have been added into your table!

 

CRM_Select

Success: XXX Rows, Failure 0,XXX

Signature
                
CRM_Select(QueryName : String,
                            CRM_Files : String,
                            FieldsNames : String,
                            Conditions : String,
                            OrderBy : String,
                            Limit : Integer,
                            GroupBy : String);
                
            
Demo
                
VAR Result  : String;
VAR Result2 : String;
VAR FileID  : String;
VAR ValueStr: String;
VAR Count,i : Integer;

FileID  := '8';
Result  := CRM_Select('Query1',FileID, '*','', '',1);
Count   := Query_RecordsCount('Query1');

Result := MenuItemAdd('MyMenu','Select', '', '', '', '', '', '', '', '');

Query_First('Query1');
FOR i:=0 TO PRED(Count) DO
(
	ValueStr := Query_FieldValue('Query1', 'Name');
	Result   := MenuItemAdd('MyMenu',IntToStr(i+1)+'. '+ValueStr, ValueStr, IntToStr(i+1) , '', '', '', '', '', '', '');

	Query_Next('Query1');
);

Result := InputMenu('MyMenu', 60000, '', '');
Exit;

                
            

 

CRM_Insert

Success: 1 Row Inserted, Failure 0,XXX

Signature
                
CRM_Insert(FileID, FieldsNames, FieldsValues, ValuesSeperator : String);
                
            
Demo
                
VAR Result  : String;
VAR Result2 : String;
VAR FileID  : String;
VAR ValuesSeperator: String;
VAR Count,i : Integer;

FileID  		:= '8';
ValuesSeperator := '+*-*k+*+m+*+d+*+';

Result  := CRM_Insert(FileID, 'CustomerCode,Name', '1' + ValuesSeperator + 'User1', ValuesSeperator);
Exit;

                
            

 

CRM_Update

Success: XXX Rows updated, Failure 0,XXX

Signature
                

CRM_Update(FileID : String,
                    CustomerCode : String,
                    FieldsNames : String,
                    FieldsValues : String,
                    ValuesSeperator : String);
                
            

 

CRM_Delete

Success: XXX Rows deleted, Failure 0,XXX

Signature
                
CRM_Delete(FileID : String, Condition : String);
                
            


Demos
External Payments


Our Partners

Support
      Telephone : (+237) 675979899 / 676009100
      Email : fm_support@f-m.fm
      P.O Box : 774 BAFOUSSAM
Available On

no
no

Further Market Inc
Copyright © 2012-2021.