Data getting deleted when updating record despite using first_notempty

QuentinH

Hello guys,

I have a funnel divided into two parts:

1. Get a quote
2. Subscribe

When the user obtain the quote, I execute a POST request to my user table in order to create the record and put all the infos.

Then, if the user wants to go further and subscribe, he pursues in the funnel and add information (email, phone, name, etc.). At the end of the subscribtion, I do a POST/user/{user_id} in order to update the existing record and write the new data I had not written previously.

So, in this second call, I only send info from the subscription.

Nevertheless, it erases my data from my first call (the one that allows them to get a quote).

I'm using the first_notempty in "Edit Record In", but somehow it doesn't work. (Using WeWeb as frontend).

Thank you guys

And the second call

Lefteris - blupry.com

Hi @QuentinH,

From what I see, you are using the first_notempty filter in the wrong way.

The edit value should remain as it is, but the filter value should be changed to user_1.column_name.

For example, regarding the Company_Name column, it should be like that

but the marked area needs to be user_1.Company_Name.

Hope that helps!

QuentinH

Thanks for your help but I don't get you. The column is called "Company_Name"

EDIT: I got it with the helpf of this video:

https://www.youtube.com/watch?v=WvOlaXmoq5o

Thank you again @Lefteris - Buynocodeapps for setting me on track