Can I set 2 data type in One Column?

AppSheet AppSheet Q&A
1

here is the thing that…
one of my column have 2 possible data types
either or

is there anyway to set 2 data types for certain column?
plz I’m stuck here.

2

Nope

1 Like
3

Curious why you need two data types for one col…

Anyway you probably just have to settle for LONGTEXT and use EXTRACTDATES or other text manipulation to get dates to process.

1 Like
4

@mcaolandrew312

I am not talking about the data type of the columns, but the schema settings of the table.

Perhaps you prepare 3 columns and process them as follows.

Column1: Need a Expiration date

  • Yes/No Type

Column2: Expiration date

  • Date type
  • Required if [Need an Expiration date] is true.

Column3: Remark.

  • longtext type
  • Required if [Need an Expiration date] is false.