When you add a new column at the end of the sheet, Superjoin ensures that this column remains intact through data refreshes, without affecting any existing data or structure.
If you rearrange the order of columns in your sheet, rest assured that the new order will remain intact through data refreshes. Superjoin does not alter column positions once they have been rearranged by the user on Sheet.
If you try to add a new column at the beginning or in between existing columns, this action will result in the column being deleted after the next data refresh or modification, as Superjoin preserves the integrity of the imported data layout.
When modifying a row record, any changes made will be overridden by the data available at your source on the next data refresh. We recommend you to create a new column on the right of the imported data to store custom data.
If you delete a column in the middle of your sheet, Superjoin will automatically move it to the end of the sheet, ensuring that your core data structure remains consistent.
If you are working with template sheets, be aware that any modification that you make will be overwritten during the next data refresh. This ensures that the template remains up-to-date and accurately reflects any changes made to the underlying data.
Formulae Drilldown automatically populates any formulas that you have in the spreadsheet in the immediate right columns of the imported data every time you refresh the data.
This saves you the time (and hassle) of manually going into your spreadsheet and copying your formula(s) down the row(s) manually.
This feature is currently supported for the following integrations β Chargebee, HubSpot, MySQL, PostgreSQLYou can easily add/remove data columns, change the column orders or apply new filters to the existing imports without creating a new query again and again.
In Append Mode, Superjoin automatically adds new data to the existing dataset, making it ideal for continuously growing datasets. This mode operates in a mindless append fashion, meaning that new rows will be appended to the sheet during every refresh. However, it should be noted that manual refreshes are not possible in this mode, as the system automatically handles the updates for you.
When using the Flashback feature, a new sheet will be created after each refresh. This ensures that you can maintain a historical view of your data over time. The original sheet will still be refreshed with the most up-to-date data, preserving your current working dataset while allowing you to keep track of previous versions for comparison or auditing purposes.
Each spreadsheet can handle up to 10 million cells, which is the upper limit based on Google Sheetsβ spreadsheet limitations. This makes it easy to manage extensive datasets within your existing sheets.
Schedules per Sheet: You can set up to 5 refresh schedules per sheet, allowing for regular automated updates to your data without manual intervention.
Simultaneous Schedules: Superjoin does not support running multiple schedules at the same time. Each schedule is queued and executed sequentially to ensure data consistency.
Maximum Schedules Limit: Keep track of how many schedules are active at any given time. You can monitor your scheduled refreshes to make sure youβre using the system efficiently without exceeding the limit.