Skip to main content
Solved

Need help with JS includes method

R
Forum|alt.badge.img+18

I’m looping over some records and want to increment ‘i’ ONLY if both conditions below are met:

let i = 0;
for (let record of taskRecords.records) {
    if(id.includes(record.getCellValue('ID Lookup')) && record.getCellValue('Stage').includes(stage)) {
        i++;
    }
}

console.log(i);

My problem is the second condition. The cell value of the field ‘Stage’ is “This is just some dummy text | this is a string” and it’s searching for “this is a string” (this is called ‘stage’ and is a string from a previous step in an automation).

i remains 0 in this case. Can anyone explain why includes doesn’t work on the second condition? Thanks!

Best answer by Jono_Prest

What type of field is your ‘Stage’ field?

Depending on the field type it may need to be coerced into a string. Maybe try using the method getCellValueAsString instead of getCellValue?

View original
Did this topic help you find an answer to your question?

7 replies

J
  • Jono_Prest
  • Inspiring
  • 26 replies
  • Answer
  • October 8, 2021

What type of field is your ‘Stage’ field?

Depending on the field type it may need to be coerced into a string. Maybe try using the method getCellValueAsString instead of getCellValue?

kuovonne
R
2 people like this
  • kuovonne
    kuovonne
  • R
    Rupert_Hoffsch1
Alexey_Gusev
Forum|alt.badge.img+23

Hi,

just guessing - string method ‘includes’ is case-sensitive, if your “this is a string” in cell starting from capital, try to search for “his a string”

kuovonne
1 person likes this
  • kuovonne
    kuovonne
kuovonne
Forum|alt.badge.img+27
  • kuovonne
  • Brainy
  • 6000 replies
  • October 8, 2021

Here’s a generic troubleshooting tip.

Assign the cell values to variables. Then console.log all the variables before your `if`` statement. One or more of the values may not be what you expect.

Justin_Barrett
Kamille_Parks11
O
3 people like this
  • Justin_Barrett
    Justin_Barrett
  • Kamille_Parks11
    Kamille_Parks11
  • O
    Olpy_Acaflo
D
Forum|alt.badge.img+17
kuovonne wrote:

Here’s a generic troubleshooting tip.

Assign the cell values to variables. Then console.log all the variables before your `if`` statement. One or more of the values may not be what you expect.


On top of that, if you’re polling non-array stuff with Array.prototype.includes, you’re going to have a bad time, that syntax only works due to destructuring coercion shenanigans which really aren’t the type of behavior you want your code to depend on. Look into substring/substr methods if the cell value is a string.

kuovonne
Forum|alt.badge.img+27
  • kuovonne
  • Brainy
  • 6000 replies
  • October 8, 2021
Dominik_Bosnjak wrote:

On top of that, if you’re polling non-array stuff with Array.prototype.includes, you’re going to have a bad time, that syntax only works due to destructuring coercion shenanigans which really aren’t the type of behavior you want your code to depend on. Look into substring/substr methods if the cell value is a string.


Both strings and arrays have an includes() method. So, if you don’t know what data type you have (array versus string), you might get expected results for the wrong reasons.

R
Forum|alt.badge.img+18
Jono_Prest wrote:

What type of field is your ‘Stage’ field?

Depending on the field type it may need to be coerced into a string. Maybe try using the method getCellValueAsString instead of getCellValue?


This was it. I was running .includes on an object and not a string. So that worked, thank you!

J
1 person likes this
  • J
    Jono_Prest
R
Forum|alt.badge.img+18
Dominik_Bosnjak wrote:

On top of that, if you’re polling non-array stuff with Array.prototype.includes, you’re going to have a bad time, that syntax only works due to destructuring coercion shenanigans which really aren’t the type of behavior you want your code to depend on. Look into substring/substr methods if the cell value is a string.


As @kuovonne mentioned, .includes exists for strings as well. For my understanding (JS noob here): where do you see the issue with that? Thanks

Reply


Most helpful members this week

Terms & Conditions