I am trying to get single row in object format but dont know why always getting null in front end. Where backend functing giving me correct output.
This is the output i am getting in console in backend appscript
This is main function that giving me output
This is the function in front end i am getting null here
Instead of using getValues
, use getDisplayValues()
, this is will return date as string, which is the cause of getting null in client side
as date is prohibited.
Reference:-