Copy Rollable Table - Change ID..

I am creating rollable tables for Random Encounters. I create one, and want another that is very similar (different weights mainly/only). But I cannot copy that, and update the copy as no option, so I transmogrify it to another game, update and rename. But now I cannot copy back to original game, as the (I am assuming) internal Id is the same. Any way around this impasse, or am I doomed to making similar tables...each manually?

The Aaron (who else!) has a script for that, which I used in the past and slightly modified. Here's my modified version, which was updated to fix a very small bug (it wasn't handling the ampersand [&amp;] escapes properly): // Github:&nbsp; &nbsp;<a href="https://github.com/shdwjk/Roll20API/blob/master/TableExport/TableExport.js" rel="nofollow">https://github.com/shdwjk/Roll20API/blob/master/TableExport/TableExport.js</a> // By:&nbsp; &nbsp; &nbsp; &nbsp;The Aaron, Arcane Scriptomancer // Contact:&nbsp; <a href="https://app.roll20.net/users/104025/the-aaron" rel="nofollow">https://app.roll20.net/users/104025/the-aaron</a> var TableExport = TableExport || (function() { 'use strict'; var version&nbsp; = '0.2.5', &nbsp; &nbsp; &nbsp; &nbsp; lastUpdate = 1576529132, &nbsp; &nbsp; &nbsp; &nbsp; tableCache = {}, &nbsp; &nbsp; &nbsp; &nbsp; escapes = { &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '['&nbsp; &nbsp;: '&lt;%%91%%&gt;', &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ']'&nbsp; &nbsp;: '&lt;%%93%%&gt;', &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '--' : '&lt;%%-%%&gt;', &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' --' : '[TABLEEXPORT:ESCAPE]', &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '&amp;' : '&lt;%%amp%%&gt;' &nbsp; &nbsp; &nbsp; &nbsp; }, &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; esRE = function (s) { &nbsp; &nbsp; &nbsp; &nbsp; var escapeForRegexp = /(\\|\/|\[|\]|\(|\)|\{|\}|\?|\+|\*|\||\.|\^|\$)/g; &nbsp; &nbsp; &nbsp; &nbsp; return s.replace(escapeForRegexp,"\\$1"); &nbsp; &nbsp; }, ch = function (c) { var entities = { '&lt;' : 'lt', '&gt;' : 'gt', "'" : '#39', '@' : '#64', &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '*' : 'ast', &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '`' : '#96', '{' : '#123', '|' : '#124', '}' : '#125', '[' : '#91', ']' : '#93', '"' : 'quot', '-' : 'mdash', ' ' : 'nbsp', &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '&amp;' : 'amp' }; if(_.has(entities,c) ){ return ('&amp;'+entities[c]+';'); } return ''; }, checkInstall = function() { &nbsp; &nbsp; &nbsp; &nbsp; log('-=&gt; TableExport v'+version+' &lt;=-&nbsp; ['+(new Date(lastUpdate*1000))+']'); }, showHelp = function() { sendChat('', &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '/w gm ' +'&lt;div style="border: 1px solid black; background-color: white; padding: 3px 3px;"&gt;' +'&lt;div style="font-weight: bold; border-bottom: 1px solid black;font-size: 130%;"&gt;' +'TableExport v'+version +'&lt;/div&gt;' +'&lt;div style="padding-left:10px;margin-bottom:3px;"&gt;' +'&lt;p&gt;This script dumps commands to the chat for reconstructing a rollable table on another campaign.&nbsp; While this can be done on your own campaigns via the transmogrifier, this script allows you to pass those commands to a friend and thus share your own creative works with others.&lt;p&gt;' +'&lt;p&gt;&lt;b&gt;Caveat:&lt;/b&gt; Avatar images that are not in your own library will be ignored by the API on import, but will not prevent creation of the table and table items.&lt;/p&gt;' +'&lt;/div&gt;' +'&lt;b&gt;Commands&lt;/b&gt;' +'&lt;div style="padding-left:10px;"&gt;' +'&lt;b&gt;&lt;span style="font-family: serif;"&gt;!export-table --'+ch('&lt;')+'Table Name'+ch('&gt;')+' [ --'+ch('&lt;')+'Table Name'+ch('&gt;')+' ...]&lt;/span&gt;&lt;/b&gt;' +'&lt;div style="padding-left: 10px;padding-right:20px"&gt;' +'&lt;p&gt;For all table names, case is ignored and you may use partial names so long as they are unique.&nbsp; For example, '+ch('"')+'King Maximillian'+ch('"')+' could be called '+ch('"')+'max'+ch('"')+' as long as '+ch('"')+'max'+ch('"')+' does not appear in any other table names.&nbsp; Exception:&nbsp; An exact match will trump a partial match.&nbsp; In the previous example, if a table named '+ch('"')+'Max'+ch('"')+' existed, it would be the only table matched for &lt;b&gt;--max&lt;/b&gt;.&lt;/p&gt;' +'&lt;ul&gt;' +'&lt;li style="border-top: 1px solid #ccc;border-bottom: 1px solid #ccc;"&gt;' +'&lt;b&gt;&lt;span style="font-family: serif;"&gt;--'+ch('&lt;')+'Table Name'+ch('&gt;')+'&lt;/span&gt;&lt;/b&gt; '+ch('-')+' This is the name of a table to export.&nbsp; You can specify as many tables as you like in a single command.' +'&lt;/li&gt; ' +'&lt;/ul&gt;' +'&lt;/div&gt;' +'&lt;/div&gt;' &nbsp; &nbsp; +'&lt;div style="padding-left:10px;"&gt;' +'&lt;b&gt;&lt;span style="font-family: serif;"&gt;!import-table --'+ch('&lt;')+'Table Name'+ch('&gt;')+' --'+ch('&lt;')+'[ show | hide ]'+ch('&gt;')+'&lt;/span&gt;&lt;/b&gt;' +'&lt;div style="padding-left: 10px;padding-right:20px"&gt;' +'&lt;p&gt;This is the command output by &lt;b&gt;!export-table&lt;/b&gt; to create the new table.&nbsp; You likely will not need issue these commands directly.&lt;/p&gt;' +'&lt;ul&gt;' +'&lt;li style="border-top: 1px solid #ccc;border-bottom: 1px solid #ccc;"&gt;' +'&lt;b&gt;&lt;span style="font-family: serif;"&gt;--'+ch('&lt;')+'Table Name'+ch('&gt;')+'&lt;/span&gt;&lt;/b&gt; '+ch('-')+' This is the name of the table to be create.' +'&lt;/li&gt; ' &nbsp; &nbsp; +'&lt;li style="border-top: 1px solid #ccc;border-bottom: 1px solid #ccc;"&gt;' +'&lt;b&gt;&lt;span style="font-family: serif;"&gt;--'+ch('&lt;')+'[ show | hide ]'+ch('&gt;')+'&lt;/span&gt;&lt;/b&gt; '+ch('-')+' This whether to show the table to players or hide it.' +'&lt;/li&gt; ' +'&lt;/ul&gt;' +'&lt;/div&gt;' +'&lt;/div&gt;' &nbsp; &nbsp; +'&lt;div style="padding-left:10px;"&gt;' &nbsp; &nbsp; +'&lt;b&gt;&lt;span style="font-family: serif;"&gt;!import-table-item --'+ch('&lt;')+'Table Name'+ch('&gt;')+' --'+ch('&lt;')+'Table Item Name'+ch('&gt;')+' --'+ch('&lt;')+'Weight'+ch('&gt;')+' --'+ch('&lt;')+'Avatar URL'+ch('&gt;')+'&lt;/span&gt;&lt;/b&gt;' +'&lt;div style="padding-left: 10px;padding-right:20px"&gt;' +'&lt;p&gt;This is the command output by &lt;b&gt;!export-table&lt;/b&gt; to create the new table.&nbsp; You likely will not need issue these commands directly.&lt;/p&gt;' +'&lt;ul&gt;' +'&lt;li style="border-top: 1px solid #ccc;border-bottom: 1px solid #ccc;"&gt;' +'&lt;b&gt;&lt;span style="font-family: serif;"&gt;--'+ch('&lt;')+'Table Name'+ch('&gt;')+'&lt;/span&gt;&lt;/b&gt; '+ch('-')+' This is the name of the table to add items to.&nbsp; &lt;b&gt;Note:&lt;/b&gt; unlike for &lt;b&gt;!export-table&lt;/b&gt;, this must be an exact name match to the created table.' +'&lt;/li&gt; ' &nbsp; &nbsp; +'&lt;li style="border-top: 1px solid #ccc;border-bottom: 1px solid #ccc;"&gt;' +'&lt;b&gt;&lt;span style="font-family: serif;"&gt;--'+ch('&lt;')+'Table Item Name'+ch('&gt;')+'&lt;/span&gt;&lt;/b&gt; '+ch('-')+' This is the name of the table item to create.&nbsp; &lt;b&gt;Note:&lt;/b&gt; Because the string '+ch('"')+' --'+ch('"')+' may occur in a table item name, you may see '+ch('"')+'[TABLEEXPORT:ESCAPE]'+ch('"')+' show up as a replacement in these commands.&nbsp; This value is corrected internally to the correct '+ch('"')+' --'+ch('"')+' sequence on import.' +'&lt;/li&gt; ' &nbsp; &nbsp; +'&lt;li style="border-top: 1px solid #ccc;border-bottom: 1px solid #ccc;"&gt;' +'&lt;b&gt;&lt;span style="font-family: serif;"&gt;--'+ch('&lt;')+'Weight'+ch('&gt;')+'&lt;/span&gt;&lt;/b&gt; '+ch('-')+' This is the weight for this table item and should be an integer value.' +'&lt;/li&gt; ' &nbsp; &nbsp; +'&lt;li style="border-top: 1px solid #ccc;border-bottom: 1px solid #ccc;"&gt;' +'&lt;b&gt;&lt;span style="font-family: serif;"&gt;--'+ch('&lt;')+'Avatar URL'+ch('&gt;')+'&lt;/span&gt;&lt;/b&gt; '+ch('-')+' This is the URL for the avatar image of the table item.' +'&lt;/li&gt; ' +'&lt;/ul&gt;' +'&lt;/div&gt;' +'&lt;/div&gt;' +'&lt;/div&gt;' ); }, &nbsp; &nbsp; nameEscape = (function(){ &nbsp; &nbsp; &nbsp; &nbsp; var re=new RegExp('('+_.map(_.keys(escapes),esRE).join('|')+')','g'); &nbsp; &nbsp; &nbsp; &nbsp; return function(s){ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return s.replace(re, function(c){ return escapes[c] || c; }); &nbsp; &nbsp; &nbsp; &nbsp; }; &nbsp; &nbsp; }()), &nbsp; &nbsp; nameUnescape = (function(){ &nbsp; &nbsp; &nbsp; &nbsp; var sepacse = _.invert(escapes), &nbsp; &nbsp; &nbsp; &nbsp; re=new RegExp('('+_.map(_.keys(sepacse),esRE).join('|')+')','g'); &nbsp; &nbsp; &nbsp; &nbsp; return function(s){ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return s.replace(re, function(c){ return sepacse[c] || c; }); &nbsp; &nbsp; &nbsp; &nbsp; }; &nbsp; &nbsp; }()), handleInput = function(msg) { var args, matches, tables, tableIDs=[], errors=[], items, itemMatches, accum=''; if (msg.type !== "api" || !playerIsGM(msg.playerid)) { return; } args = msg.content.split(/\s+/); switch(args[0]) { case '!import-table': args = msg.content.split(/\s+--/); if(args.length === 1) { showHelp(); break; } if(_.has(tableCache,args[1])) { sendChat('','/w gm ' +'&lt;div style="border: 1px solid black; background-color: white; padding: 3px 3px;"&gt;' +'&lt;span style="font-weight:bold;color:#990000;"&gt;Warning:&lt;/span&gt; ' +'Table ['+args[1]+'] already exists, skipping create.' +'&lt;/div&gt;' ); } else { tableIDs=findObjs({type: 'rollabletable', name: args[1]}); if(tableIDs.length) { sendChat('','/w gm ' &nbsp; &nbsp; &nbsp; &nbsp; +'&lt;div style="border: 1px solid black; background-color: white; padding: 3px 3px;"&gt;' &nbsp; &nbsp; +'&lt;span style="font-weight:bold;color:#990000;"&gt;Warning:&lt;/span&gt; ' &nbsp; &nbsp; +'Table ['+args[1]+'] already exists, skipping create.' &nbsp; &nbsp; +'&lt;/div&gt;' ); } else { tableIDs=createObj('rollabletable',{&nbsp; name: args[1],&nbsp; showplayers: ('show'===args[2]) }); tableCache[args[1]]=tableIDs.id; } } break; case '!import-table-item': args = msg.content.split(/\s+--/); if(args.length === 1) { showHelp(); break; } args[2] = nameUnescape(args[2]); if(!_.has(tableCache,args[1])) { tableIDs=findObjs({type: 'rollabletable', name: args[1]}); if(!tableIDs.length) { sendChat('','/w gm ' &nbsp; &nbsp; &nbsp; &nbsp; +'&lt;div style="border: 1px solid black; background-color: white; padding: 3px 3px;"&gt;' &nbsp; &nbsp; +'&lt;span style="font-weight:bold;color:#990000;"&gt;Error:&lt;/span&gt; ' &nbsp; &nbsp; +'Table ['+args[1]+'] doesn not exist.&nbsp; Cannot create table item.' &nbsp; &nbsp; +'&lt;/div&gt;' &nbsp; &nbsp; ); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else { &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; tableCache[args[1]]=tableIDs[0].id; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; createObj('tableitem',{ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; name: args[2], &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rollabletableid: tableCache[args[1]], &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; weight: parseInt(args[3],10)||1, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; avatar: args[4]||'' &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; case '!export-table': &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; args = msg.content.split(/\s+--/); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(args.length === 1) { &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; showHelp(); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } tables=findObjs({type: 'rollabletable'}); matches=_.chain(args) .rest() .map(function(n){ var l=_.filter(tables,function(t){ return t.get('name').toLowerCase() === n.toLowerCase(); }); return ( 1 === l.length ? l : _.filter(tables,function(t){ return -1 !== t.get('name').toLowerCase().indexOf(n.toLowerCase()); })); }) .value(); _.each(matches,function(o,idx){ if(1 !== o.length) { if(o.length) { errors.push('Rollable Table [&lt;b&gt;'+args[idx+1]+'&lt;/b&gt;] is ambiguous and matches '+o.length+' names: &lt;b&gt;&lt;i&gt; '+_.map(o,function(e){ return e.get('name'); }).join(', ')+'&lt;/i&gt;&lt;/b&gt;'); } else { errors.push('Rollable Table [&lt;b&gt;'+args[idx+1]+'&lt;/b&gt;] does not match any names.'); } } },errors); if(errors.length) { sendChat('','/w gm ' +'&lt;div style="border: 1px solid black; background-color: white; padding: 3px 3px;"&gt;' +'&lt;div&gt;&lt;span style="font-weight:bold;color:#990000;"&gt;Error:&lt;/span&gt; ' +errors.join('&lt;/div&gt;&lt;div&gt;&lt;span style="font-weight:bold;color:#990000;"&gt;Error:&lt;/span&gt; ') +'&lt;/div&gt;' +'&lt;/div&gt;' ); break; } if( ! errors.length) { matches=_.chain(matches) .flatten(true) .map(function(t){ tableIDs.push(t.id); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return t; }) .value(); items=findObjs({type: 'tableitem'}); itemMatches=_.chain(items) .filter(function(i){ return _.contains(tableIDs,i.get('rollabletableid')); }) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .reduce(function(memo,e){ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(!_.has(memo,e.get('rollabletableid'))) { &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; memo[e.get('rollabletableid')]=[e]; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else { &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; memo[e.get('rollabletableid')].push(e); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return memo; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },{}) .value(); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; _.each(matches, function(t){ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; accum+='!import-table --'+nameEscape(t.get('name'))+' --'+(t.get('showplayers') ? 'show' : 'hide')+'&lt;br&gt;'; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; _.each(itemMatches[t.id], function(i){ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; accum+='!import-table-item --'+nameEscape(t.get('name'))+' --'+nameEscape(i.get('name'))+' --'+i.get('weight')+' --'+i.get('avatar')+'&lt;br&gt;'; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sendChat('', '/w gm '+accum); } break; } }, &nbsp; &nbsp; handleRemoveTable = function(obj){ &nbsp; &nbsp; &nbsp; &nbsp; tableCache = _.without(tableCache,obj.id); &nbsp; &nbsp; }, registerEventHandlers = function() { on('chat:message', handleInput); &nbsp; &nbsp; &nbsp; &nbsp; on('destroy:rollabletable', handleRemoveTable); }; return { CheckInstall: checkInstall, RegisterEventHandlers: registerEventHandlers }; }()); on("ready",function(){ 'use strict'; TableExport.CheckInstall(); TableExport.RegisterEventHandlers(); }); if you want the original, I got it from the Roll20 github, here: &nbsp;&nbsp;&nbsp;&nbsp; <a href="https://github.com/shdwjk/Roll20API/blob/master/TableExport/TableExport.js" rel="nofollow">https://github.com/shdwjk/Roll20API/blob/master/TableExport/TableExport.js</a> This allows you to export and import tables!

Since you have a Pro subscription, you can use TableExport to export the table and make adjustments, then import it back in and it'll have a new table ID. Or it's also pretty simple to just throw the table into an Excel or Google Sheets spreadsheet and using a CONCAT function to create the list of TableExport commands to create the tables.&nbsp; Here's an example of what I use: A B C D E F G H 1 MACRO Name Weight Import Table Table Name Item Name % 2 =CONCATENATE(E2,F2,G2,H2) =IF(C2="","!import-table","!import-table-item") =CONCATENATE(" --",RandomEncounters) =IF(C2="","",CONCATENATE(" --",C2)) =IF(C2=""," --hide"," --",D2) 3 =CONCATENATE(E3,F3,G3,H3) Orcs [[2d4]] 1 =IF(C3="","!import-table","!import-table-item") =CONCATENATE(" --",RandomEncounters) =IF(C3="","",CONCATENATE(" --",C3)) =IF(C3=""," --hide"," --",D3) You only have to worry about filling out columns B and C and copying the rest of the formulas down.&nbsp; Columns D, E, F, G, and H will be combined together in column B, and then you can just select the entire column and paste it into chat to use TableExport. You may need to add a SUBSTITUTE function column as well if there are special characters (especially left and right brackets) that need to be parsed by TableExport and not by the Roll20 dice roller when the table is imported. In column A (starting on row 2), that would be this: =SUBSTITUTE(SUBSTITUTE(B2,"[",&lt;%%91%%&gt;),"]",&lt;%%93%%&gt;)

Thankyou both

I'll also plug my TableToTable script... which can get tables into HTML form (in a handout), and read tables from there, too. So you can build your table in Excel, Google Sheets, etc., then import it. I did a series of videos on it.

Hmm, having some trouble... nothing happens!&nbsp; I removed the --Hide and still see nothing.&nbsp; Added the table, and additem does nothing. Cannot get any of the functionality to work - shows nothing in either chat window or API sandbox (except the "-=&gt; TableExport v0.2.5 &lt;=-&nbsp; [Mon Dec 16 2019 20:45:32 GMT+0000 (Coordinated Universal Time)]" ) Tried both the normal and experimental - same Is this supposed to work on Jumpgate? How do I turn on verbose mode? Other API scripts work fine. Is this right:- !import-table --RandomEncounters !import-table-item --RandomEncounters --Orcs [[2d4]] --1

timmaugh said: I'll also plug my TableToTable script... which can get tables into HTML form (in a handout), and read tables from there, too. So you can build your table in Excel, Google Sheets, etc., then import it. I did a series of videos on it. I see the menu, but seems to not function - clearly I am doing something wrong somewhere.&nbsp; But for example the Help Panel info shows when I hover, but I cannot click it. The three Get/new/Append work as far as selecting a table, or new name, but then don't do anything. I do not access sites like that - and anyway I find video-learning much less effective than text. Thanks for trying!

I just tried the script in my game and it worked fine. The idea is you run export table and it creates the import script, so you can copy/paste it into another game. Here's a sample: Command (NB: I already have the table, called CT-1_CrushCritical in my game) : !export-table --CT-1_CrushCritical Output : !import-table --CT-1_CrushCritical --show !import-table-item --CT-1_CrushCritical -- &lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=-49-05}} {{Description=Weak grip. No extra damage.}} --55 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=06-20}} {{Description=Minor fracture of ribs.}} {{Hits = +5}} {{Wound = Broken Rib}} {{Activity = -5}} --15 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=21-35}} {{Description=Blow to side.}} {{Hits = +4}} {{Activity = -40 x 1 round}} --15 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=36-50}} {{Description=Blow to forearm.}} {{Hits = +5}} {{Stunned = 1 round}} --15 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=51-65}} {{Description=Blow to shield shoulder breaks shield. If no shield: shoulder broken, arm useless.}} {{Hits = +5}} {{w/o shield: Wound = Shield Arm - Shoulder Broken}} --15 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=66-79}} {{Description=Blow breaks bone in leg.}} {{Hits = +12}} {{Wound = Broken Leg}} {{Activity = -40}} {{Stunned = 2 rounds}} --14 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=80}} {{Description=Strike to forehead.}} {{Hits = +30}} {{Wound = Eye Destroyed}} {{Stunned = 24 rounds}} {{w/o helm = 1 month coma}} --1 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=81-86}} {{Description=Blow breaks weapon arm. Arm useless. Tendon damage.}} {{Hits = +8}} {{Wound = Weapon Arm - Broken and Tendon Damaged}} {{Stunned = 2 rounds}} --6 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=87-89}} {{Description=Shatter knee.}} {{Hits = +9}} {{Wound = Knee Shattered}} {{Activity = -60}} {{Condition = Downed}} {{Stunned = 3 rounds}} --3 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=90}} {{Description=Blow to back of neck paralyzes from the shoulders down.}} {{Hits = +25}} {{Wound = Neck - Broken and Nerve Destroyed}} {{Condition = Paralyzed}} --1 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=91-96}} {{Description=Unconscious for 4 hours due to blow to side of head.}} {{Hits = +20}} {{w/o helm = Skull Crushed, Dead}} --6 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=97-99}} {{Description=Blast to chest sends ribcage though lungs. Drops and dies in 6 rounds. Vicious.}} {{Condition = Dead in 6 rounds}} --3 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=100}} {{Description=Blow to jaw drives bone into brain. Dies instantly.}} {{Condition = Dead}} --1 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=101-106}} {{Description=Blow breaks hip.}} {{Hits = +15}} {{Wound = Hip Broken}} {{Activity = -75}} {{Condition = Downed}} {{Stunned = 3 rounds}} --6 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=107-109}} {{Description=Neck strike crushes throat. Cannot breath and stunned. Poor fool then expires.}} {{Wound = Throat Crushed}} {{Stunned = 12 rounds}} {{Condition = Dead in 12 rounds}} --3 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=110}} {{Description=Crushes hip.}} {{Hits = +35}} {{Wound = Hip Crushed and Nerves Destroyed}} {{Stunned = 2 rounds}} {{Condition = Dead in 6 rounds}} --1 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=111-116}} {{Description=Shatter elbow in weapon arm. Arm useless.}} {{Hits = +35}} {{Wound = Weapon Arm Elbow Shattered}} {{Stunned = 5 rounds}} --6 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=117-119}} {{Description=Blow to side crushes chest cavity. Drops and dies in 3 rounds.}} {{Wound = Chest Crushed, Multiple Organs and Bones Destroyed}} {{Condition = Downed, Dead in 3 rounds}} --3 -- !import-table-item --CT-1_CrushCritical --&lt;%%amp%%&gt;{template:default} {{name=Crush Critical Result}} {{Roll=120}} {{Description=Blast to chest area. Destroy heart, foe dies immediately. Fine work.}} {{Hits = +25}} {{Wound = Heart Destroyed}} {{Condition = Dead}} --1 -- I've not enabled Jumpgate in my game , so not sure if that would affect any of the script behaviour. If you want to test this in your game, you can use the above commands in reverse, e.g. run that import script followed by the export command.

I tried it in a non-Jumpgate game and worked I copied that game to make it Jumpgate - also works Retried in the game I want it in - did not work. So must be a clash of scripts? - I have a lot of API scripts in that game.&nbsp; It's midnight here so I will sort it out later ....&nbsp; Probably create in a new game then copy over using the Transmogrifier, or try disabling some API. Or just have a game for random encounters which I run as well as main game!

Ok so I have two test games now, one Legacy, one Jumpgate. In both I can create random encounter tables, using the script Manny posted. !import-table --RandomEncounters !import-table-item --RandomEncounters --Orcs [[2d4]] --1 Issue is that it posts as Orcs $[[0]] not Orcs [[2d4]] I fix this in the table manually and does not roll when use the roll (with or without the $).&nbsp; So I find and use Rollable Table Macros and the versio without $ rolls the value, in both Legacy and Jumpgate. So how do I stop that script adding the $ .. I used the one linked (the original) and also adds the $ I assume it is this code - &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var entities = { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '&lt;' : 'lt', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '&gt;' : 'gt', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "'" : '#39', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '@' : '#64', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '*' : 'ast', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '`' : '#96', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '{' : '#123', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '|' : '#124', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '}' : '#125', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '[' : '#91', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ']' : '#93', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '"' : 'quot', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '-' : 'mdash', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ' ' : 'nbsp', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '&amp;' : 'amp' &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(_.has(entities,c) ){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return ('&amp;'+entities[c]+';'); So why is it there?&nbsp; Anyway I removed the two lines &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '[' : '#91', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ']' : '#93', and still converts [[2d4]] into $[[0]] Tried /[[2d4]] and \[[2d4]] but just added the extra character.

The TableExport command needs to 'escape' the brackets (so that Roll20 doesn't recognize them as a roll when the command is first entered into chat), so it should look like this instead: !import-table --RandomEncounters !import-table-item --RandomEncounters --Orcs&nbsp;&lt;%%91%%&gt;&lt;%%91%%&gt;2d4&lt;%%93%%&gt;&lt;%%93%%&gt;&nbsp;--1

Jarren said: The TableExport command needs to 'escape' the brackets (so that Roll20 doesn't recognize them as a roll when the command is first entered into chat), so it should look like this instead: !import-table --RandomEncounters !import-table-item --RandomEncounters --Orcs&nbsp;&lt;%%91%%&gt;&lt;%%91%%&gt;2d4&lt;%%93%%&gt;&lt;%%93%%&gt;&nbsp;--1 Thanks Jarren.&nbsp; That fixed it. Sadly I have now to build the tables I have been putting off, lol