When will the Tablemaster App be available to use in Wix Studio
Use Tablemaster App in Wix Studio
It is not currently available so can’t try anything.
You do not have to wait for Table-Master, because there are surely enough alternatives you can use.
What kind of functions do you need, which you have used in table-master ?
- ???
- ???
- ???
-???
The only alternative is google sheets table and that also isn’t available in Wix Studio yet either. I can use it in wix editor and screenshot it but it looks bad. I had expected after the studio had been released for four months one or both of these would have been available.
Why not creating your own → TABLE-MASTER ???
Ok, maybe this will take some time to write the wanted software, but then it will be exactly like expected including exactly the functionalities you want.
You can start with a absolut simple example and UPGRADE it to make it better by adding it more and more functions and features…
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Table Editor</title>
<style>
table {
border-collapse: collapse;
width: 100%;
}
table, th, td {
border: 1px solid black;
}
th, td {
padding: 8px;
text-align: left;
}
</style>
</head>
<body>
<h2>Table Editor</h2>
<button onclick="addRow()">Add Row</button>
<button onclick="addColumn()">Add Column</button>
<button onclick="deleteRow()">Delete Row</button>
<button onclick="deleteColumn()">Delete Column</button>
<table id="editableTable">
<tr>
<th>Header 1</th>
<th>Header 2</th>
<th>Header 3</th>
</tr>
<tr>
<td contenteditable="true">Row 1, Cell 1</td>
<td contenteditable="true">Row 1, Cell 2</td>
<td contenteditable="true">Row 1, Cell 3</td>
</tr>
<tr>
<td contenteditable="true">Row 2, Cell 1</td>
<td contenteditable="true">Row 2, Cell 2</td>
<td contenteditable="true">Row 2, Cell 3</td>
</tr>
</table>
<script>
function addRow() {
var table = document.getElementById('editableTable');
var newRow = table.insertRow(-1); // Insert at the end
var cell;
for (var i = 0; i < table.rows[0].cells.length; i++) {
cell = newRow.insertCell(i);
cell.contentEditable = true;
cell.innerHTML = 'New Row, Cell ' + (i + 1);
}
}
function addColumn() {
var table = document.getElementById('editableTable');
for (var i = 0; i < table.rows.length; i++) {
var cell = table.rows[i].insertCell(-1); // Insert at the end
cell.contentEditable = true;
cell.innerHTML = 'New Column, Cell ' + (table.rows[i].cells.length);
}
}
function deleteRow() {
var table = document.getElementById('editableTable');
if (table.rows.length > 1) {
table.deleteRow(-1); // Delete the last row
}
}
function deleteColumn() {
var table = document.getElementById('editableTable');
if (table.rows[0].cells.length > 1) {
for (var i = 0; i < table.rows.length; i++) {
table.rows[i].deleteCell(-1); // Delete the last cell in each row
}
}
}
</script>
</body>
</html>
Add this into an iFrame (HTML-Component) save the setup and test it.
You will have to expand the code and connect the HTML-Component with your Wix-page to activate the communication.
Start coding beyond boundaries!!!
Well which basic functions your new creted tool should have ?
When working with tables, especially in the context of databases or spreadsheets, several important functions come into play. The specific functions you use may depend on the software or platform you’re working with, but here are some general functions that are commonly used:
- SELECT: Retrieves data from one or more tables. It is a fundamental function in querying databases.
- INSERT: Adds new rows of data into a table. This is used to insert new records.
- UPDATE: Modifies existing data in a table. You can use it to change the values of specific columns in existing records.
- DELETE: Removes rows from a table based on a specified condition. It is used to delete records from a table.
- WHERE Clause: Filters data based on a specified condition. It is often used in conjunction with SELECT, UPDATE, and DELETE statements.
- ORDER BY Clause: Sorts the result set of a query in ascending or descending order based on one or more columns.
- GROUP BY Clause: Groups rows that have the same values in specified columns into summary rows. This is often used with aggregate functions like COUNT, SUM, AVG, etc.
- JOIN: Combines rows from two or more tables based on a related column between them. Different types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.
- Aggregate Functions: Functions like COUNT, SUM, AVG, MIN, and MAX are used to perform calculations on a set of values. These are often used with GROUP BY to summarize data.
- INDEX: Improves the speed of data retrieval operations on a database table. It enhances the speed of SELECT queries but may slow down INSERT, UPDATE, and DELETE operations.
- UNION and UNION ALL: Combine the result sets of two or more SELECT statements. UNION removes duplicate rows, while UNION ALL includes all rows.
- Subqueries: Queries embedded within another query. They can be used to retrieve data that will be used in the main query’s condition.
- Constraints: Enforce rules on the data in a table. Common constraints include PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, and CHECK.
These functions and clauses provide a robust set of tools for managing and manipulating data in tables. Depending on your specific needs and the complexity of your data, you may use a combination of these functions to achieve your desired outcomes.
After some more efforts & UPGRADES → it already starts to look better…
Why don’t I? Firstly because it is not my job to create apps for them and secondly I don’t code, I just want to use the current Table Master App with wix studio and find it absurd that is not already available. Why launch a product to market that has less functionality?
1 Like
THANK YOU !!!
This is what i wanted to hear!
Just wanted to hear it from you. 
Yes, your thoughts & statements are absolutely RIGHT !
I agree with you, about that.
And i also do not love such behaviour of Wix, when they introduce incomplete products, especialy when the whole story repeats again.
However, on other side → wix has grown and is now offering more APIs for coders, this is why i like wix.
I also understand when you say → i want just to create a website, not using any codings.
But i would recommend you to learn a little bit of coding, this will improve your skills regarding —> websitebuilding.
Firstly because it is not my job to create apps for them
Oh, here you are not coding for them :-), you are generating functions (apps) for your own, which you can use. The advantage of such own created codings → it will work EXACTLY like you want it to work, EXACTLY like you expect.
This was a very good question!
Why launch a product to market that has less functionality?