{"id":29994,"date":"2024-07-18T14:32:26","date_gmt":"2024-07-18T14:32:26","guid":{"rendered":"https:\/\/kb.sambapos.com\/?p=29994"},"modified":"2024-12-30T14:26:57","modified_gmt":"2024-12-30T14:26:57","slug":"4-90-how-to-create-tables-on-the-fly","status":"publish","type":"post","link":"https:\/\/kb.sambapos.com\/en\/4-90-how-to-create-tables-on-the-fly\/","title":{"rendered":"4.90. How to Create Tables On The Fly?"},"content":{"rendered":"

In this document, it will be explained how to create tables on the fly on SambaPOS.<\/p>\n

 <\/p>\n

1. Adding Entity Screen<\/strong><\/h2>\n

Main Menu > Manage > Entities > Entity Screens ><\/strong> Here, click on Add Entity Screen<\/strong> button.<\/p>\n

General Settings Section;<\/strong><\/p>\n

\"\"<\/p>\n

Name:\u00a0<\/strong>Instant Created Tables<\/p>\n

View Mode:\u00a0<\/strong>Layout<\/p>\n

 <\/p>\n

Entity List Section;<\/strong><\/p>\n

\"\"<\/p>\n

Entity Type:\u00a0<\/strong>Tables<\/p>\n

 <\/p>\n

Mappings Section;<\/strong><\/p>\n

\"\"<\/p>\n

In here, add a line by clicking on Add<\/strong> button.<\/p>\n

After completing necesssary editings click on Save<\/strong> button.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

2. Adding Automation Command<\/strong><\/h2>\n

Main Menu > Manage > Automation > Automation Commands ><\/strong> Here, click on Add Automation Command<\/strong>\u00a0button.<\/p>\n

General Settings Section;<\/strong><\/p>\n

\"\"<\/p>\n

Name:<\/strong> Table<\/p>\n

Button Header:<\/strong> Table<\/p>\n

 <\/p>\n

Mappings Section;<\/strong><\/p>\n

\"\"<\/p>\n

Leave the Mappings section empty.<\/p>\n

After completing necesssary editings click on Save<\/strong> button.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

3. Adding Actions<\/strong><\/h2>\n

3.1. Adding Change Ticket Entity (Generic) Action<\/strong><\/h3>\n

Main Menu > Manage > Automation > Actions ><\/strong> Here, click on Add Action <\/strong>button.<\/p>\n

\"\"<\/p>\n

Action Name:<\/strong> Change Ticket Entity (Generic)<\/p>\n

Action Type:<\/strong> Change Ticket Entity<\/p>\n

Can Create Ticket:<\/strong> True<\/p>\n

Can Create Entity:<\/strong> True<\/p>\n

Entity Type Name:<\/strong> Tables<\/p>\n

Entity Name:<\/strong> [:EntityName]<\/p>\n

Update Null Entity:<\/strong> True<\/p>\n

After completing necesssary editings click on Save<\/strong> button.<\/p>\n

 <\/p>\n

 <\/p>\n

3.2. Adding Display Payment Screen Action<\/strong><\/h3>\n

Main Menu > Manage > Automation > Actions ><\/strong> Here, click on Add Action <\/strong>button.<\/p>\n

\"\"<\/p>\n

Action Name:<\/strong> Display Ticket<\/p>\n

Action Type:<\/strong> Display Ticket<\/p>\n

Parameters:<\/strong><\/p>\n

Ticket Id:<\/strong> [:ticket id]<\/p>\n

After completing necesssary editings click on Save<\/strong> button.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

3.3. Adding Execute Automation Command – Table Selection Action<\/strong><\/h3>\n

Main Menu > Manage > Automation > Actions ><\/strong> Here, click on Add Action <\/strong>button.<\/p>\n

\"\"<\/p>\n

Action Name:<\/strong> Execute Automation Command – Table Selection<\/p>\n

Action Type:<\/strong> Execute Automation Command<\/p>\n

Parameters:<\/strong><\/p>\n

Automation Command Name:<\/strong> Select Table Execute<\/p>\n

Command Value:<\/strong> [:commandValue]<\/p>\n

After completing necesssary editings click on Save<\/strong> button.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

3.4. Adding Show Message Action<\/strong><\/h3>\n

Main Menu > Manage > Automation > Actions ><\/strong> Here, click on Add Action <\/strong>button.<\/p>\n

\"\"<\/p>\n

Action Name:<\/strong> Show Message<\/p>\n

Action Type:<\/strong> Show Message<\/p>\n

Parameters:<\/strong><\/p>\n

Message:<\/strong> [:message]<\/p>\n

After completing necesssary editings click on Save<\/strong> button.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

3.5. Adding Update Program Setting Action<\/strong><\/h3>\n

Main Menu > Manage > Automation > Actions ><\/strong> Here, click on Add Action <\/strong>button.<\/p>\n

\"\"<\/p>\n

Action Name:<\/strong> Update Program Setting<\/p>\n

Action Type:<\/strong> Update Program Setting<\/p>\n

Parameters:<\/strong><\/p>\n

Setting Name:<\/strong> [:settingName]<\/p>\n

Setting Value:<\/strong> [:settingValue]<\/p>\n

Update Type:<\/strong> Update<\/p>\n

Is Local:<\/strong> False<\/p>\n

After completing necesssary editings click on Save<\/strong> button.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

4. Adding Rules<\/strong><\/h2>\n

4.1. Adding Select Table Ask Rule<\/strong><\/h3>\n

Main Menu > Manage > Automation > Rules ><\/strong> Here, click on Add Rule <\/strong>button.<\/p>\n

\"\"<\/p>\n

Rule Name:<\/strong> Select Table Ask<\/p>\n

Event Name:\u00a0<\/strong>Automation Command Executed<\/p>\n

Execute Rule If:<\/strong> Matches<\/p>\n

Add Custom Constraints:<\/strong><\/p>\n

Automation Command Name|Equals|Table<\/p>\n

Select Actions:<\/strong><\/p>\n

Action-1: Update Program Setting<\/strong><\/p>\n

SettingsName:<\/strong> Table<\/p>\n

SettingValue: [?Table;;;OC;\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\",\"0\",\"<backspace>\"|\"q\",\"w\",\"e\",\"r\",\"t\",\"y\",\"u\",\"i\",\"o\",\"p\"|\"a\",\"s\",\"d\",\"f\",\"g\",\"h\",\"j\",\"k\",\"l\"|\"z\",\"x\",\"c\",\"v\",\"b\",\"n\",\"m\"|\"<space>\",\".\"]<\/code><\/strong><\/p>\n

 <\/p>\n

Action-2: Execute Automation Command – Table Selection<\/strong><\/p>\n

CommandValue:\u00a0<\/strong>[:Table]<\/p>\n

After completing necesssary editings click on Save<\/strong> button.<\/p>\n

 <\/p>\n

 <\/p>\n

4.2. Adding Select Table Execute – Check Rule<\/strong><\/h3>\n

Main Menu > Manage > Automation > Rules ><\/strong> Here, click on Add Rule <\/strong>button.<\/p>\n

\"\"<\/p>\n

Rule Name:<\/strong> Select Table Execute – Check<\/p>\n

Event Name:\u00a0<\/strong>Automation Command Executed<\/p>\n

Execute Rule If:<\/strong> Matches All<\/p>\n

Add Custom Constraints:<\/strong><\/p>\n

Automation Command Name|Equals|Select Table Execute<\/p>\n

Command Value|Is Not Null|<\/p>\n

Select Actions:<\/strong><\/p>\n

Action-1: Change Ticket Entity (Generic)<\/strong><\/p>\n

Constraint:\u00a0'{REPORT TICKET DETAILS:T.Id:(TS.Status=Unpaid) and (TEN.Tables=[:CommandValue])}' == ''<\/code><\/strong><\/p>\n

EntityName:<\/strong> [:CommandValue]<\/p>\n

 <\/p>\n

Action-2: Display Ticket<\/strong><\/p>\n

Constraint:\u00a0'{REPORT TICKET DETAILS:T.Id:(TS.Status=Unpaid) and (TEN.Tables=[:CommandValue])}' == ''<\/code><\/strong><\/p>\n

 <\/p>\n

Action-3: Show Message<\/strong><\/p>\n

Constraint:\u00a0'{REPORT TICKET DETAILS:T.Id:(TS.Status=Unpaid) and (TEN.Tables=[:CommandValue])}' != ''<\/code><\/strong><\/p>\n

Message:\u00a0<\/strong>Table is already occupied!<\/p>\n

After completing necesssary editings click on Save<\/strong> button.<\/p>\n

 <\/p>\n

5. Editing Instant Created Tables Entity Screen<\/strong><\/h2>\n

Main Menu > POS > Instant Created Tables ><\/strong> In here, activate Design Mode<\/strong> by right clicking mouse and add New Table Automation Command Button<\/strong> and Entity Grid Widgets<\/strong> as shown in the below video file;<\/p>\n