Can i use an inside input from a database trigger?

Hey!

Im new here so this question might be silly

I want to use a database trigger to run a function. This function requires an input. When I set up the database trigger I can refrence only the new/old json. The NEW json holds the input i need yet im not sure how to fetch it and use it

I tried using the dot notation to get the data from the json file (as seen in the image bellow) yet it tells me that my input type is wrong

Is that possible? if so, how?

Thanks!

3 replies