And again a very special question. I want to push users to finish their User Profile and Fill all the values after registration.
What I’m doing now is to ask only a few minimal questions for User Onboarding. But then I need to tell them on their User Dashboard that they only filled : 60% of their Profile. That would force the user to complete their profile. But not sure how to properly handle that. I mean columns like, Street, Phone, Adress can be checked for NULL values. But not sure how to handle that into a single MySQL query. Maybe go with JSON and handle that with expressions? Or maybe purely by SQL Statement? @Hyperbytes I guess you know that
What is your logic here? I mean - you have let’s say 20 db fields per user. If he enters some info in 10 of them and leaves the rest empty - does that mean the profile is 50% complete?
no calculated SQL fields in Wappler yet. so calculate percentage complete at client side. easy enough, just test for empty or zero values on fields and build the percentage from there I.e complete = (fieldname.empty()?10:0) + …
sorry can’t do it in full or check syntax, using phone on a train to london (hate the place so not a happy person)
@Teodor exactly. I think I don’t take every column deeply in detail. I think If I can reach with 10 Columns and 10 are filled = 100%.
Just basic stuff… I won’t check if Infos are really VALID. Maybe I could, before inserting values, I’ll do some basic Check. Like min length for a street or for phone number. And only then Phone number is stored. That would give 1 Point. So each Column = 1 Point …
If having that proper code here on left with (open_times ? 10 : 0) and edit the expression, it strips me the double dot (divide symbol) and it looks like that:
