Layout Extra fields
Not only extra tabs and fields can be created, it is also possible to give it a special layout including sub-tabs.
This can be done with the LAYOUTSETTING field.
Below some examples:
LINK TO WABA ON BUSINESS MANAGER |
GroupName:=[GENERAL-]/<1> |
CUSTOMERS PERSONAL EMAIL |
GroupName:=[GENERAL-]/<1> |
CUSTOMERS VERTICAL |
GroupName:=[GENERAL-]/<1> |
API KEY |
GroupName:=[GENERAL-]/<1> |
SALES CONTACT FROM NEXMO |
GroupName:=[GENERAL-]/<1> |
ESTIMATED MONTHY VOLUME |
GroupName:=[GENERAL-]/<1> |
ESTIMATED PEAK MESSAGES / SECOND |
GroupName:=[GENERAL-]/<1> |
FACEBOOK MANAGER BUSINESS ID |
GroupName:=<2->/{CalcTab}/Business Template Registration Details| |
EMAIL ADDRESSED TO ADD TO WABA |
GroupName:=<2->/{CalcTab}/Business Template Registration Details| |
CUSTOMER NAME |
GroupName:=<2->/{CalcTab}/WhatsApp Provisioning Details| |
COUNTRY CODE |
GroupName:=<2->/{CalcTab}/WhatsApp Provisioning Details| |
DO YOU WANT USE A LVN |
GroupName:=<2->/{CalcTab}/WhatsApp Provisioning Details| |
WHATSAPP NUMBER |
GroupName:=<2->/{CalcTab}/WhatsApp Provisioning Details| |
ABOUT SECTION |
GroupName:=<2->/{CalcTab}/WhatsApp Provisioning Details| |
BUSINESS DESCRIPTION |
GroupName:=<2->/{CalcTab}/WhatsApp Provisioning Details| |
VERTICAL |
GroupName:=<2->/{CalcTab}/WhatsApp Provisioning Details| |
COMPANY EMAIL FOR WHATSAPP PROFILE |
GroupName:=<2->/{CalcTab}/WhatsApp Provisioning Details| |
WEBSITE |
GroupName:=<2->/{CalcTab}/WhatsApp Provisioning Details| |
ADDRESS |
GroupName:=<2->/{CalcTab}/WhatsApp Provisioning Details| |
URL TO LOGO |
GroupName:=<2->/{CalcTab}/WhatsApp Provisioning Details| |
Will result into:
Fields dependent of each other:
Example 1:
Select ‘value’ from dual where ‘combolist value’ = ‘[#extrafieldlabel#]’ (see example below)
SELECT 'GEOGRAPHY' FROM DUAL WHERE 'SITE' = '[#IMS AREA#]'
UNION
SELECT 'OTHER' FROM DUAL WHERE 'SITE' = '[#IMS AREA#]'
UNION
SELECT 'ACTIVE EQ.' FROM DUAL WHERE 'EQUIPMENT' = '[#IMS AREA#]'
UNION
SELECT 'PASSIVE EQ.' FROM DUAL WHERE 'EQUIPMENT' = '[#IMS AREA#]'
UNION
SELECT 'PHYSICAL' FROM DUAL WHERE 'CIRCUIT' = '[#IMS AREA#]'
UNION
SELECT 'LOGICAL' FROM DUAL WHERE 'CIRCUIT' = '[#IMS AREA#]'
UNION
SELECT 'VIEWS' FROM DUAL WHERE 'CIRCUIT' = '[#IMS AREA#]'
UNION
SELECT 'CABLING' FROM DUAL WHERE 'CIRCUIT' = '[#IMS AREA#]'
UNION
SELECT 'BULK LOADER' FROM DUAL WHERE 'SYSTEM' = '[#IMS AREA#]'
UNION
SELECT 'EXTRA FIELDS' FROM DUAL WHERE 'SYSTEM' = '[#IMS AREA#]'
Fields dependent of each other with the use of a table:
Example 1:
SELECT DISTINCT FIELD2
FROM TABLE_XYZ
WHERE FIELD2 IS NOT NULL
AND
FIELD1 = '[#FIELD1#]'
ORDER BY FIELD2
(the values in column Field2 are related to the values in column Field1)
Or
Example 2:
SELECT DISTINCT FIELD3
FROM TABLE_XYZ
WHERE FIELD3 IS NOT NULL
AND
FIELD2 = '[#FIELD2#]'
ORDER BY FIELD3
(the values in column Field3 are related to the values in column Field2)
TABLE_XYZ
FIELD1 |
FIELD2 |
FIELD3 |
FIELD4 |
FIELD5 |
Value1 |
Value11 |
|
|
Value18 |
Value1 |
Value12 |
|
|
|
Value2 |
Value13 |
Value14 |
|
|
Value3 |
|
Value15 |
|
Value19 |
Value1 |
Value11 |
Value16 |
Value17 |
|
Value4 |
|
|
|
|
Value5 |
|
|
|
|
Value1 |
|
|
|
Value19 |
Value3 |
Value12 |
|
|
|