# \#data-table **URL:** https://forums.losant.com/tag/data-table/41.md [Latest](https://forums.losant.com/latest.md) · [Categories](https://forums.losant.com/categories.md) · [Tags](https://forums.losant.com/tags.md) --- ## [Using Tables To Give Devices Large Amount of Tags](https://forums.losant.com/t/using-tables-to-give-devices-large-amount-of-tags/5665)
**Author:** [@Tanner\_Williams](https://forums.losant.com/u/Tanner_Williams)\ **Replies:** 4\ **Last updated:** [October 31, 2024, 2:45pm UTC](https://forums.losant.com/t/using-tables-to-give-devices-large-amount-of-tags/5665 "2024-10-31T14:45:24Z")
So I saw this post referencing that And also At the current time, I don’t believe we have enough users or devices for our plan to exceed the tag limit. However, I’m considering, for the future, a solution for stori… --- ## [Indicator block and values from Data table](https://forums.losant.com/t/indicator-block-and-values-from-data-table/5654)
**Author:** [@Surya\_Kapisetti](https://forums.losant.com/u/Surya_Kapisetti)\ **Replies:** 2\ **Last updated:** [October 24, 2024, 11:49pm UTC](https://forums.losant.com/t/indicator-block-and-values-from-data-table/5654 "2024-10-24T23:49:20Z")
I have a Data table which consists of device information. I have an indicator block in a dashboard. I have Query-0 in indicator block that stores the value in “value-0” In the condition section of the Indicator block .… --- ## [Reporting question](https://forums.losant.com/t/reporting-question/5343)
**Author:** [@Dave\_Blaylock](https://forums.losant.com/u/Dave_Blaylock)\ **Replies:** 1\ **Last updated:** [November 30, 2023, 6:52pm UTC](https://forums.losant.com/t/reporting-question/5343 "2023-11-30T18:52:20Z")
I am looking for guidance. I have been dabbling around Losant for the last 3 years working through understanding the application that we had programmed for our company. Unfortunately with all the other hats I wear here I… --- ## [Filter on tables seems broken](https://forums.losant.com/t/filter-on-tables-seems-broken/5291)
**Author:** [@Paolo\_Proxy](https://forums.losant.com/u/Paolo_Proxy)\ **Replies:** 2\ **Last updated:** [October 16, 2023, 2:57pm UTC](https://forums.losant.com/t/filter-on-tables-seems-broken/5291 "2023-10-16T14:57:03Z")
Hi there, I think there is a problem here but then look at the Node table, same query it returns me zero entries --- ## [Weekly Average Table](https://forums.losant.com/t/weekly-average-table/4996)
**Author:** [@Ciara\_Keyes](https://forums.losant.com/u/Ciara_Keyes)\ **Replies:** 1\ **Last updated:** [March 27, 2023, 2:26pm UTC](https://forums.losant.com/t/weekly-average-table/4996 "2023-03-27T14:26:37Z")
Hi all, I was hoping if someone could point me in the right direction. I have a customer html block at present that for each row shows the weekly averages of sensor readings (each column is the average temperature, numb… --- ## [How we can change losant table header bg color and text color?](https://forums.losant.com/t/how-we-can-change-losant-table-header-bg-color-and-text-color/4966)
**Author:** [@Dinesh\_Kumar](https://forums.losant.com/u/Dinesh_Kumar)\ **Replies:** 2\ **Last updated:** [March 10, 2023, 2:40am UTC](https://forums.losant.com/t/how-we-can-change-losant-table-header-bg-color-and-text-color/4966 "2023-03-10T02:40:12Z")
I am writing the below code in custom section of pages , but it is not reflecting in site .ReactVirtualized\_\_Table\_\_headerRow { background-color:orange; color:white; } --- ## [Update table from Input Controls Block](https://forums.losant.com/t/update-table-from-input-controls-block/4930)
**Author:** [@Cesar\_Guedes](https://forums.losant.com/u/Cesar_Guedes)\ **Replies:** 4\ **Last updated:** [February 14, 2023, 11:04am UTC](https://forums.losant.com/t/update-table-from-input-controls-block/4930 "2023-02-14T11:04:12Z")
Hello! I was wondering if it is possible to update a data table through the Input Controls Block of a dashboard. For example: Wanting to change the value of a singe row/column, I’ve tried something like this: Bu… --- ## [Database management](https://forums.losant.com/t/database-management/4893)
**Author:** [@Mohit\_Agrawal](https://forums.losant.com/u/Mohit_Agrawal)\ **Replies:** 1\ **Last updated:** [January 19, 2023, 2:12pm UTC](https://forums.losant.com/t/database-management/4893 "2023-01-19T14:12:05Z")
Hi, Can you please help me with resources around database management on Losant platform and around database management at the edge on Losant Mohit --- ## [Operating with two data tables](https://forums.losant.com/t/operating-with-two-data-tables/4886)
**Author:** [@Cesar\_Guedes](https://forums.losant.com/u/Cesar_Guedes)\ **Replies:** 2\ **Last updated:** [January 18, 2023, 6:40pm UTC](https://forums.losant.com/t/operating-with-two-data-tables/4886 "2023-01-18T18:40:24Z")
Hello! I’m unsuccesfully trying to make a simple operation using, simultaneously, two data tables. Here is the deal: A specific item from the first row of table A should have its value multiplied by a specific item fro… --- ## [Custom Chart Block is not reading all data](https://forums.losant.com/t/custom-chart-block-is-not-reading-all-data/4819)
**Author:** [@Luisa\_Rodrigues](https://forums.losant.com/u/Luisa_Rodrigues)\ **Replies:** 2\ **Last updated:** [November 27, 2022, 3:45pm UTC](https://forums.losant.com/t/custom-chart-block-is-not-reading-all-data/4819 "2022-11-27T15:45:49Z")
Hello! I’m trying to make a graph using a data from a data table (custom chart block). However, the graph is only reading 1000 of my 10040 rows. How can I include all data? Thanks in advance! My script: { “width”: {… --- ## [Data Table trigger node](https://forums.losant.com/t/data-table-trigger-node/4788)
**Author:** [@Maximiliano\_Gibert](https://forums.losant.com/u/Maximiliano_Gibert)\ **Replies:** 4\ **Last updated:** [October 26, 2022, 6:56pm UTC](https://forums.losant.com/t/data-table-trigger-node/4788 "2022-10-26T18:56:33Z")
Hi! I want to know if when a table row is deleted after 180 days, fire the data table trigger node in a workflow? Thank you!!! --- ## [Override created\_at and updated\_at for row insert](https://forums.losant.com/t/override-created-at-and-updated-at-for-row-insert/4704)
**Author:** [@Paolo\_Proxy](https://forums.losant.com/u/Paolo_Proxy)\ **Replies:** 1\ **Last updated:** [August 29, 2022, 5:16pm UTC](https://forums.losant.com/t/override-created-at-and-updated-at-for-row-insert/4704 "2022-08-29T17:16:15Z")
Would it be possible to override the created\_at and updated\_at timestamps during the insertion of a row into a table. This is because I have to setup specific timestamps for later visualization purposes. Right now I ha… --- ## [Export specific rows from data table](https://forums.losant.com/t/export-specific-rows-from-data-table/4624)
**Author:** [@Eduardo\_wewer](https://forums.losant.com/u/Eduardo_wewer)\ **Replies:** 2\ **Last updated:** [July 5, 2022, 2:17pm UTC](https://forums.losant.com/t/export-specific-rows-from-data-table/4624 "2022-07-05T14:17:32Z")
Hello, I am trying to export only specific (fields) columns from a data table. Is this possible? If so could you show me how? I am not familiar with MongoDB. thanks --- ## [Dashboard time filter of Table data](https://forums.losant.com/t/dashboard-time-filter-of-table-data/4621)
**Author:** [@Paolo\_Proxy](https://forums.losant.com/u/Paolo_Proxy)\ **Replies:** 2\ **Last updated:** [June 30, 2022, 8:24pm UTC](https://forums.losant.com/t/dashboard-time-filter-of-table-data/4621 "2022-06-30T20:24:22Z")
Hi there, I noticed that in the dashboard the time filter doesn’t work on the created\_at/updated\_at of the data table. Example below What would be a way to filter by created\_at or updated\_at ? Do I have to create … --- ## [Column width on data table block](https://forums.losant.com/t/column-width-on-data-table-block/4462)
**Author:** [@Jeroen\_Bruinsma](https://forums.losant.com/u/Jeroen_Bruinsma)\ **Replies:** 1\ **Last updated:** [April 13, 2022, 2:35pm UTC](https://forums.losant.com/t/column-width-on-data-table-block/4462 "2022-04-13T14:35:42Z")
Hello, Small request; it would be nice to be able to adjust the column width of the data table block on a dashboard. I now end up in the situation that some information is being cut off(red in screenshot below) where I … --- ## [Data table limits](https://forums.losant.com/t/data-table-limits/4124)
**Author:** [@Jonatas\_Liasch](https://forums.losant.com/u/Jonatas_Liasch)\ **Replies:** 4\ **Last updated:** [October 19, 2021, 5:32pm UTC](https://forums.losant.com/t/data-table-limits/4124 "2021-10-19T17:32:57Z")
Hi i am using a free losant account I’m writing data in a data table, but it started to show this message “Failed to create row! Cannot add row/s - account over maximum allowed storage” My data table did not reach th… --- ## [Error on importing exported DataTables](https://forums.losant.com/t/error-on-importing-exported-datatables/4127)
**Author:** [@Thiago\_Andrey\_Zils](https://forums.losant.com/u/Thiago_Andrey_Zils)\ **Replies:** 1\ **Last updated:** [October 19, 2021, 1:33pm UTC](https://forums.losant.com/t/error-on-importing-exported-datatables/4127 "2021-10-19T13:33:36Z")
Hello, I was moving some data from one datatable to another using export and importing that archive into my new datatable. On fields that were null, when i imported my data again, it filled with a string “null”. --- ## [Max String length on Database column](https://forums.losant.com/t/max-string-length-on-database-column/3546)
**Author:** [@Suroor\_Wijdan](https://forums.losant.com/u/Suroor_Wijdan)\ **Replies:** 8\ **Last updated:** [July 16, 2021, 8:58pm UTC](https://forums.losant.com/t/max-string-length-on-database-column/3546 "2021-07-16T20:58:00Z")
Hi team, We are trying to store a JSON value on a data table which will then be parsed and used as roles and permissions for experience users. The problem we are facing is that we get an error that the string size is gr… --- ## [Amount of date I can get from a data table saved](https://forums.losant.com/t/amount-of-date-i-can-get-from-a-data-table-saved/3863)
**Author:** [@Gabriel\_Guitarrari](https://forums.losant.com/u/Gabriel_Guitarrari)\ **Replies:** 2\ **Last updated:** [June 21, 2021, 12:51pm UTC](https://forums.losant.com/t/amount-of-date-i-can-get-from-a-data-table-saved/3863 "2021-06-21T12:51:20Z")
How many MB of data can i get from a specific data table save on Data Tables, to the workflow? --- ## [Table Limit Reached](https://forums.losant.com/t/table-limit-reached/3845)
**Author:** [@David\_MacKenzie](https://forums.losant.com/u/David_MacKenzie)\ **Replies:** 2\ **Last updated:** [June 14, 2021, 2:06pm UTC](https://forums.losant.com/t/table-limit-reached/3845 "2021-06-14T14:06:29Z")
I have been a naughty partner and filled my table storage quota (1GB). I am happy to delete records and free up space, but when I try I keep getting a “Network Error Fail”. It is about 3 million records. Is this too m… --- ## [Data table maximum size](https://forums.losant.com/t/data-table-maximum-size/3819)
**Author:** [@Wesley\_Manning](https://forums.losant.com/u/Wesley_Manning)\ **Replies:** 2\ **Last updated:** [June 1, 2021, 8:18pm UTC](https://forums.losant.com/t/data-table-maximum-size/3819 "2021-06-01T20:18:34Z")
What is the maximum size in bytes for a data table? Documentation mentions this is a hard limit but I don’t see the max size anywhere in the docs or our organizations usage page. --- ## [Handlebar template for tableID](https://forums.losant.com/t/handlebar-template-for-tableid/3348)
**Author:** [@Josh\_Bell](https://forums.losant.com/u/Josh_Bell)\ **Replies:** 4\ **Last updated:** [October 20, 2020, 7:35pm UTC](https://forums.losant.com/t/handlebar-template-for-tableid/3348 "2020-10-20T19:35:26Z")
Hi I am trying to reference a dataTable using handlebar template in my workflow, ideally i want the workflow to loop through a bunch of tables. I cant seem to make the template work, i just get an error table not found,… --- ## [Customizable table blocks](https://forums.losant.com/t/customizable-table-blocks/3124)
**Author:** [@MindTheLab\_FIND](https://forums.losant.com/u/MindTheLab_FIND)\ **Replies:** 2\ **Last updated:** [July 27, 2020, 9:50am UTC](https://forums.losant.com/t/customizable-table-blocks/3124 "2020-07-27T09:50:58Z")
Hello everyone, I am part of the team of the Interaction Design Lab at the University of Siena. I am here to write you to tell about our experience with your platform and to ask you a question about it. For one of our… --- ## [Retrieving the largest value from a data table in a workflow](https://forums.losant.com/t/retrieving-the-largest-value-from-a-data-table-in-a-workflow/2952)
**Author:** [@Elisa\_Cui](https://forums.losant.com/u/Elisa_Cui)\ **Replies:** 1\ **Last updated:** [May 18, 2020, 8:32pm UTC](https://forums.losant.com/t/retrieving-the-largest-value-from-a-data-table-in-a-workflow/2952 "2020-05-18T20:32:01Z")
Hi, so i have a question on retrieving a row from a data table. I have a workflow built to retrieve information from my API and insert it into the table. once the information is in the table, like this How do i retrie… --- ## [DataTable Advance Query Aggregation](https://forums.losant.com/t/datatable-advance-query-aggregation/2786)
**Author:** [@Raghu\_S1](https://forums.losant.com/u/Raghu_S1)\ **Replies:** 3\ **Last updated:** [April 3, 2020, 3:58pm UTC](https://forums.losant.com/t/datatable-advance-query-aggregation/2786 "2020-04-03T15:58:14Z")
Hi Losant Team, It is possible to use Aggregation function like $sum,$avg,$group,$match,$first,$last, and $max in Losant DataTable advance query filter options? --- ## [Is there a possibility for read/write inconsistency in Data Tables?](https://forums.losant.com/t/is-there-a-possibility-for-read-write-inconsistency-in-data-tables/2676)
**Author:** [@Alexander\_Farley1](https://forums.losant.com/u/Alexander_Farley1)\ **Replies:** 13\ **Last updated:** [March 16, 2020, 10:11pm UTC](https://forums.losant.com/t/is-there-a-possibility-for-read-write-inconsistency-in-data-tables/2676 "2020-03-16T22:11:26Z")
We have some pages/workflows which edit rows in a Data Table. I’ve noticed that sometimes, a write will succeed, but the page we are redirected to looks like the values haven’t been updated. Then, I reload the page and t… --- ## [How to get default value on new row when 'Add if not found' of Table Update Row node](https://forums.losant.com/t/how-to-get-default-value-on-new-row-when-add-if-not-found-of-table-update-row-node/2730)
**Author:** [@Phil\_Deibel](https://forums.losant.com/u/Phil_Deibel)\ **Replies:** 3\ **Last updated:** [March 13, 2020, 2:50pm UTC](https://forums.losant.com/t/how-to-get-default-value-on-new-row-when-add-if-not-found-of-table-update-row-node/2730 "2020-03-13T14:50:21Z")
I have a default value of true set for a boolean column, I am using the Table Update node and it’s Add row if not found. I have the update set to change the value to false as the update, but new rows are being updated t… --- ## [Show/hide data table dashboard block columns](https://forums.losant.com/t/show-hide-data-table-dashboard-block-columns/1099)
**Author:** [@Christopher\_Penney](https://forums.losant.com/u/Christopher_Penney)\ **Replies:** 5\ **Last updated:** [April 24, 2019, 3:18pm UTC](https://forums.losant.com/t/show-hide-data-table-dashboard-block-columns/1099 "2019-04-24T15:18:37Z")
Would be really useful to be able to hide certain columns on the data table dashboard block. --- ## [Data Table Keeping Track of Gateway Information Redundant?](https://forums.losant.com/t/data-table-keeping-track-of-gateway-information-redundant/1670)
**Author:** [@Leo\_Bach1](https://forums.losant.com/u/Leo_Bach1)\ **Replies:** 5\ **Last updated:** [March 26, 2019, 10:41pm UTC](https://forums.losant.com/t/data-table-keeping-track-of-gateway-information-redundant/1670 "2019-03-26T22:41:36Z")
Setting up automatic device creation/registration based on the blog: https://www.losant.com/blog/how-devices-can-register-themselves-in-losant. My high level business process currently looks like this: Purchase gatewa… --- ## [Exporting table data with losant api node](https://forums.losant.com/t/exporting-table-data-with-losant-api-node/1637)
**Author:** [@Lars\_Andersson](https://forums.losant.com/u/Lars_Andersson)\ **Replies:** 1\ **Last updated:** [March 20, 2019, 9:15pm UTC](https://forums.losant.com/t/exporting-table-data-with-losant-api-node/1637 "2019-03-20T21:15:20Z")
how can I select just the fields I want, and not get every column? [Next page](https://forums.losant.com/tag/data-table/41.md?match_all_tags=true&page=1&tags%5B%5D=data-table)