In a search I'm displaying on the Dashboard I'm using an 'ID' field in the format '000001', '000002' etc, however when it is being displayed it is being converted to number datatype and the preceding 0s are removed. (turns it into 1, 2 etc)
I need to preserve this as a text type as I'm then using it as a token value for other searches ?
I should mention this is specifically for the Dashboard Studio