Display different image based on how long since sign up

[izumiinoue]

Is it possible to rotate between different images based on the number of weeks/months since a user has signed up? I’m already collecting the sign up date for each user in the Users table, how should I go about setting this up?

For example:

• Week 1 (<7 days) since sign up, show image A
• Week 2 (7~14 days) since sign up, show image B
• Month 2 (30~60 days) since sign up, show image C

For context, it’s meant to be a ‘Quote of the Week/Month’ section on my home page.

[ThinhDinh]

• Create a Date Difference column with the start date being users’ Sign Up date, and the end date being “Now”.

• Choose the appropriate number of days/weeks you need, and show/hide your images based on that number of days/weeks.

[izumiinoue]

Thanks Thinh, I’ve set up the date difference column in my Users table.

But do you mind breaking down the 2nd part? What are the exact steps to show/hide the images (I have a separate table with the quote images uploaded)? Sorry, newbie here.

[ThinhDinh]

You can use the visibility conditions for the image component and show/hide it based on a User Profiles column value. Point it to the column where you calculate your date difference and adjust as needed.