Filter by actual linked record object

[Christian_L]

Hi,

I am stuck with the following (most probably simple) problem -

• I am getting a records list of a table
• I am filtering the list acc to 3 criteria (name, type, date) 
• this all works fine, I log a correctly filtered object in the console
• then I want to get the value of the column with the name „tac_descr“ (variable set at the beginning of the script) of the found object/row.
• This should be done in the „active_descr“ definition
• Pls see the error in the console; no clue what is wrong; I have the correct object filtered (active_immo_tacs) and I just want to display the cell value of the column „tac_descr“ of „active_immo_tacs“. 

Could anyone pls help me on that? thank you very much - I am now trying to solve this since hours…

[Sho · Accepted solution]

Hi @Christian_L ,

Try this one and see if it works.

console.log(active_immo_tacs[0].getCellValueAsString(tac_descer));

[Christian_L]

@Sho This is it! Thank you so much - especially for the super fast reply.

If I may add: why is this working now? The only difference to what I did, is that you add "[0]" to the variable "active_immo_tacs". Would you have an explanation or refence to that where I can read in to avoid such issues in future? thank you again, br Chris

[Sho]

I'm glad you solved the problem!
I think it would be helpful to learn how to handle arrays and objects in Javascript.

"all_tacs" and "active_immo_tacs" are arrays containing record objects.
The getCellValue function can only be used on record objects in this array.
Therefore, specify [0] in the "active_immo_tacs" array and use the getCellValue function on it.