Hello,
I have a table with about 1700 records. I’m pulling a couple of records and doing some math on all the rows, then updating the result in a new record. The bulk update code I’m using is waaaay faster than a single row update, but it’s still tak...
Hello,
The dropdown for “Choose a View” has a narrower width than the max char size of view names. When users name a bunch of views the same initial way, it’s impossible to tell what you’re copying.
Hello,
I believe this is simple, but I don’t understand what syntax is needed. I’m trying to read the results of a single-select field as a string. I’m doing a running total calculation, but resetting it whenever a certain reading is found. The runni...
Hello,
I’m trying to learn basic scripting. I’m following some examples to get started and build a useful function, however I’m hung up pretty early on. I’m trying to pull all the entries for one specific field in a view. However, when I do this, my ...
I have a datetime field that includes data that’s precise to the second. I’d like to filter records based on an accounting window that’s somewhat unusual (like 2pm Thursday to Thursday), rather than just Thursday to Wednesday for instance. I saw ther...
Thank you! I don’t have to update every record, so that’s a great suggestion.
Do you have any examples of a mega batch update? I would have approached it the way it was discussed in the thread, but I got the impression that did not work.
The first record does have a value for that field. I can output the table and it gives me all the record IDs and names.
When I use typeOf, it says the output is a string. However, when I use the output.text() function there’s nothing printed in the c...
Hmm ok so I was missing the name or id. When I add it, I get a string output, but no string value
output.text(respGroup.records[0].getCellValueAsString(‘NDD - Responsible Group’)) returns nothing
Thank you. I must be referencing the records incorrectly. Could you help me with that syntax? I ran a test and got this output for the first index:
output.text(typeOf respGroup.records[0].getCellValueAsString) returns “Function”