The Table element lists invoices in an organized manner with the columns No, Date, Recipient, Status, Amount. The user manages invoices with sorting, searching, filtering, pagination, exporting, and (optional) in-line editing.
The Table element is supported in web and mobile applications. Mobile responsive table support is available.
Invoice Management Scenario
In a finance or subscription application, the Table element is used to allow users to track their latest invoices. The table lists the invoice number (No), invoice date (Date), recipient company or service provider (Recipient), invoice status (Status), and amount information (Amount) in an organized manner.
Connecting the Data Source
Go to the Datasources module.
Then click the + icon next to the Tables heading and name the table Invoices.
Create the following table.
Then click SQL Actions and name the action Invoices. You can also create it with C#.
Enter the following SQL command.
SELECT ‘AXZ-177’ AS InvoiceNo, CAST(‘2022-06-07’ ASDATE) AS InvoiceDate,‘Figma Inc.’ AS RecipientName, ‘https://cdn.example.com/logo/figma.png’ AS RecipientLogoUrl,‘Paid’ AS Status, 351.02AS Amount, ‘USD’ AS CurrencyUNION ALLSELECT ‘AXZ-922’,'2022-06-05',‘Dribbble’,'https://cdn.example.com/logo/dribbble.png',‘Overdue’,710.68,‘USD’UNION ALLSELECT ‘AXZ-703’,'2022-06-04',‘Youtube’,'https://cdn.example.com/logo/youtube.png',‘Paid’,778.35,‘USD’UNION ALLSELECT ‘AXZ-883’,'2022-06-02',‘Spotify’,'https://cdn.example.com/logo/spotify.png',‘Overdue’,490.51,‘USD’UNION ALLSELECT ‘AXZ-798’,'2022-06-02',‘Discord’,'https://cdn.example.com/logo/discord.png',‘Paid’,275.43,‘USD’UNION ALLSELECT ‘AXZ-154’,'2022-06-01',‘Github’,'https://cdn.example.com/logo/github.png',‘Paid’,105.55,‘USD’;
UI Design Module operations
Click the Add Action button on the right side of the application screen.
Then select Custom > Invoices.
Using Features in a Scenario Context
General
Datasource: Data source (Invoices).
ShowHeader: On → Show header rows.
Fixed Header: On → Keep header fixed when scrolling.
Editable: Off → View only.
Editable Always Active: If enabled, every cell is always in edit mode.