Skip to main content

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…

Hi @Christian_L ,

Try this one and see if it works.

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

 

@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

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.

Reply


Terms & Conditions