View Single Post
Farling
Senior Member
 
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623

Old April 30th, 2020, 10:17 AM
Release 2.12 is available

This release adds the ability to create "derived" columns, where the value of the column is based on a javascript expression, which can examine the value in other columns for each row.

In the javascript expression, you can access the value of a column called "columnname" using the following:
row.column('columnname')

The new "derived" columns are managed in a new window which can be accessed by pressing the "Custom Columns" button. Simply enter the name of the new column in the top box, and add the javascript expression in the large main box, and press Apply (or OK). Your new custom columns are saved as part of the project (old projects will load correctly, with no custom columns).

The "derived" column appears in the data table as soon as you press apply or OK; so you can see the text that will be used when your import file is generated. (If the javascript is badly formed, then the error will appear as part of the generated text.)

This release also fixes a bug that prevented excel spreadsheets from being loaded.

(Internally, the software has been updated from Qt 5.12.0 to 5.12.8.)

(I need the derived column functionality because some 5E json data has spell casting split into separate fields, and I want them in a single field.)

Farling

Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module

Donations gratefully received via Patreon, Ko-Fi or Paypal

Last edited by Farling; May 1st, 2020 at 05:36 AM.
Farling is offline   #544 Reply With Quote