I’m trying to use an integer as the ID lookup for a table - ID’s are limited to strings only from what I can tell. Any way to get around this? I want to have a ‘current build #’ incremented every build, and to look up information in another table based on this build #.
I’d recommend passing a text variable to the table. If you pull this ID in and want to manipulate it for the next one, you can use PARSEINTEGER(). Then, if you want to go the other way and turn your integer variable to a text to store back to the table, you can use an expression saying: @variable.integer + ‘’
The empty double single quotes should get you from an integer to a string.
Let me know if that helps.
@variable.integer + ‘’ is exactly what I needed, thank you!!