coltsh3lby - profile

coltsh3lby · Mar 13, 2023

Hello, I'm trying to check if my "inputValue_1" field occurs in a string pulled from a lookup field (named 'test' in the screenshot below). I'm trying to use this to check if inputValue_1 has a valid input, as defined from this lookup field.The formu...

coltsh3lby · Dec 28, 2022

Hello everybody,I have a table that's thousands of lines long, with a column called "Formula" which contains small string expressions like:amount = salary * 0.11;What I'm trying to do is run this string in my code, so that it updates the `amount` var...

coltsh3lby · Mar 14, 2023

Thanks for the help everyone! Yes, the issue was that lookups return an array, rather than a string. I wish it was easier to test these things, or receive sample outputs / error messages. I'm very used to doing this kind of stuff in Gsheets and Excel...

coltsh3lby · Dec 28, 2022

Unfortunately, it needs to run automatically. Is there ways to automate button presses using the scripting extension, or something you know of that accomplishes something similar? None of these calculations are super complicated on their face, but I’...

coltsh3lby · Dec 28, 2022

Hi Kuovonne,Thanks for your quick reply. I understand this, and this is why I’m attempting to use a function constructor instead to accomplish the same thing. Is this explicitly forbidden, like using eval() is? I feel like it shouldn’t be

User Statistics

User Activity

Confusion with simple formula using FIND() and SEARCH()

Automation Scripting – TypeError when executing code from a string.

Re: Confusion with simple formula using FIND() and SEARCH()

Re: Automation Scripting – TypeError when executing code from a string.

Re: Automation Scripting – TypeError when executing code from a string.