Conditional action on Supabase timestamptz is not functioning

[davhad]

Has your issue been reported?

• [X] I have searched the existing issues and confirm it has not been reported.
• [X] I give permission for members of the FlutterFlow team to access and test my project for the sole purpose of investigating this issue.

Current Behavior

When creating a conditional action based on a timestamptz in a Supabase row, the action cannot be completed.

Expected Behavior

You should be able to use conditional actions based on a timestamptz. For exammple, comparing it to now or to another date.

Steps to Reproduce

Create a supabse table with one of the columns being a timestamptz. Create a column querying one element from this table in Flutterflow create an on page load or on tap action flow where the first step is a conditional action. Choose the timestamptz column as the conditional field and attempt to continue that flow.

Reproducible from Blank

• [X] The steps to reproduce above start from a blank project.

Bug Report Code (Required)

IT4oz/Hqx89grs9J1s/IdfoxnSQWKW1/a50e0MpBazwbfe+uB4kqevfOTERCcNO8dEFEf1r8u2oW0/SPjoTpCsFfNQSBbJhg+boAEArvTk6nbLWaFJWge3AkM8RnGEyg4au0kxMnVLJpcWQA32eMFu+udArdGOPqNUVBDq/LZO4=

Context

Can't compare or access dates (if present or not) and therefore unable to mark the items as read.

Visual documentation

Additional Info

No response

Environment

- FlutterFlow version: 3.13.7
- Platform: Web
- Browser name and version: Chrome latest
- Operating system and version affected: Macos

[victoriahuang1]

@davhad I cannot reproduce the bug. I am able to use supabase timestamptz in conditional actions.

Based on the screenshot, it looks like you are trying to directly plug-in, the timestamptz into the condition. However, the intended case is to first select condition and then put the timestamptz as a field inside of a condition. Have you tried that?

[davhad]

What do we do if we want to set that timestamptz value on a supabase field?

-- David Haddad

On Wed, Apr 10, 2024 at 20:29 Victoria Huang @.***> wrote:

@davhad https://github.com/davhad I cannot reproduce the bug. I am able to use supabase timestamptz in conditional actions.

Based on the screenshot, it looks like you are trying to directly plug-in, the timestamptz into the condition. However, the intended case is to first select condition and then put the timestamptz as a field inside of a condition. Have you tried that? Screenshot.2024-04-10.at.12.28.15.PM.png (view on web) https://github.com/FlutterFlow/flutterflow-issues/assets/16326980/94629712-584c-48fd-893a-00ad53dff4f3

— Reply to this email directly, view it on GitHub https://github.com/FlutterFlow/flutterflow-issues/issues/2396#issuecomment-2048289352, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAARXH4DZL77KQ36ISVHOLDY4WHIVAVCNFSM6AAAAABD4TCOH6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANBYGI4DSMZVGI . You are receiving this because you were mentioned.Message ID: @.***>

[victoriahuang1]

What do we do if we want to set that timestamptz value on a supabase field?

You would use the update row action.

[davhad]

Hey Victoria, I know that :)

But are you able to set the timestamptz value on an update? If yes can you post a screenshot?

-- David Haddad

On Thu, Apr 11, 2024 at 17:48 Victoria Huang @.***> wrote:

What do we do if we want to set that timestamptz value on a supabase field?

You would use the update row action.

— Reply to this email directly, view it on GitHub https://github.com/FlutterFlow/flutterflow-issues/issues/2396#issuecomment-2050003451, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAARXH5LDHY4JZBIS43VFDLY42WDXAVCNFSM6AAAAABD4TCOH6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANJQGAYDGNBVGE . You are receiving this because you were mentioned.Message ID: @.***>

[victoriahuang1]

@davhad hope this helps

[davhad]

An arbitrary timestamptz value other than current time

-- David Haddad

On Thu, Apr 11, 2024 at 18:07 Victoria Huang @.***> wrote:

@davhad https://github.com/davhad hope this helps Screenshot.2024-04-11.at.9.06.22.AM.png (view on web) https://github.com/FlutterFlow/flutterflow-issues/assets/16326980/7284b16c-fea1-4ec6-afd0-1f1de5e5e8ae

— Reply to this email directly, view it on GitHub https://github.com/FlutterFlow/flutterflow-issues/issues/2396#issuecomment-2050038385, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAARXH5XIRPLZHNUPV5PYRTY42YK5AVCNFSM6AAAAABD4TCOH6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANJQGAZTQMZYGU . You are receiving this because you were mentioned.Message ID: @.***>

[leighajarett]

Hi @davhad this seems like you're looking for some help with your app architecture / design. I would suggest posting your question on community.flutterflow.io or reaching out to our support team.

This tracker is only for bugs reproducible from a blank project. Thank you