The Preset functionality was introduced thanks to an idea from Alessandro Pungitore and, most importantly, the full implementation by Daniel Noeth. I am very pleased that the Business Central community is actively developing Table Data Editor, and I strive to keep up. Therefore, I have also added a few new and hopefully useful features. You can now save and load preset configurations for Table Data Editor. This functionality allows you to easily create multiple profiles for working with your most frequently used tables and filters.
Literally copying one column of data to another. Of course, this won't work if your data types are significantly different.
You now have the ability to enable logging of any data changes made by Table Data Editor. By default, this setting is turned off, but you can enable it on the Table Editor Setup page. Please note that when changing a large number of records simultaneously, this functionality may negatively affect performance.
This functionality allows you to export data from a filtered table, with only the fields you have loaded being exported. You can also import this file using the import function. Additionally, you have options for handling existing records during data import. The default behavior is a runtime error, but you can choose to modify the found record or skip it. It is also worth noting that the Validation flag on the Data Editor page is used to determine whether fields and modify/insert triggers need to be validated.
By simply opening the Data Editor from the search box, you can load any table. If you enable the "Without Validation" field then all OnDelete/OnModify/OnValidate triggers will be disabled.
You can filter the received data in the same way as usual.
You can change the data in the tables, and depending on the type of field you get a pop-up window with the same type of data. For example, if you try to change a field with the type Date, a pop-up window will open with the date that you can change. Code and Text data types can be changed without opening a pop-up window.
If you want to change a field that contains a simple Table Relation, you will also have a lookup available. For example, you don't have to manually write Sell-To Customer No. on the Sales Line, you can select it from the list.
Extension also supports changing ENUMs and Options. Just click on them and you will be presented with a list to choose from.
You can also delete records from tables.
Sometimes we don't need to load the whole table in order to change some specific entries. That's why I added the ability to filter the records before loading them. You can add any field and any number of filters. In addition, the Number of Records field will display the actual number of records, taking into account the filtering.
The application now supports changing primary key values. Currently, support for up to 15 values in PK has been implemented. Why 15? I'll write about that later :) Renaming has its known limitations(see remarks section), for example you can't change Enum/Option to 0 or from 0 to another value.
Since FlowField's are almost always uneditable, you can exclude them from loading for better performance.
Sometimes it is necessary to open a table directly through a link. For such cases, your link will look like this:
You able to insert new record into opened table.
Now you can filter the list of fields before table is loaded.
It is now possible to sort the record by any available key. Since Table Data Editor uses text fields in the buffer, sorting in the UI may not be correct for fields with non-text data type.
The function allows you to update the value of the selected field for all records.
Find & Replace page allows you to find and, if necessary, replace all fields by filter. In addition, it is possible to change a specific value for a specific entry.
Remember that editing tables directly can be risky, and it’s best to avoid doing so in Production or without a clear understanding of what you’re doing!