Remove from the drop-down list if it has already been used within 24 hours

AppSheet AppSheet Q&A
1

I am using this expression NOT (IN ([_ THIS], SELECT (Yard [N FLIGHT], [DATE] = TODAY ()))) to avoid duplication, but I would like it better to be removed from the drop down list when an element has already been used in 24 hours is it possible to do this function?

Patio ([N FLIGHT]) → where the flights are registered and Program vlos ([Concat vlos]) —> referenced column for the drop-down list

I appreciate your help, I spent hours and hours and I can not make it work

2

Hi @wsaico

Can you share your table structure ? Screenshot are best.

Did you use this:
NOT (IN ([_ THIS], SELECT (Yard [N FLIGHT], [DATE] = TODAY ())))
in the valid_If field ?

You may prefer using a FILTER expression instead.

For example:

FILTER("yourTable",
 AND(
   NOW()-[TimeStamp]<1,
   otherConditions
  )
)

I assume the dropdown column is of type EnumList or Enum, base type Ref.
If not, please change it.

4 Likes
3

@Aurelien Thanks for your answer, if the expression I am using in VALID IF

Here I put the screenshots.
This is the table (ADUANAS)

3X_d_d_ddabc3b3d581ac360095a7af3170838f7c025993.png
3X_d_d_ddabc3b3d581ac360095a7af3170838f7c025993.png886×693 32.3 KB

and for the drop-down list it is referenced to the table (PROGRAM VLOS) column [Concat vlos]

3X_1_9_19a06380b916305499c4391ad955734e2c30f6d1.png
3X_1_9_19a06380b916305499c4391ad955734e2c30f6d1.png1060×739 37.5 KB

and VALID IF I have this expression … to avoid double registration during the day

3X_e_2_e298f56114d95924182d666db598b45bae69ff95.png
3X_e_2_e298f56114d95924182d666db598b45bae69ff95.png1291×799 54.3 KB

Currently this expression works wonderfully, but users suggested that the item that was already used within 24 hours should be removed from the drop-down list

1 Like
4

Hi @wsaico,

Thank you for further informations.
Again, please pick Enum instead of Ref, and set base type as Ref with source table PROGRAM VLOS.
That will work better and be easier to manage.

Based on the informations you shared, I suggest you create a slice for the PROGRAM VLOS used today.
Then, use your Valid_If based on that slice.

My suggestion:

Let’s assume [keyVuelo] is the key column of your table PROGRAM VLOS.

Let’s name the slice: “VlosToday_Slice”.
Source table : PROGRAM VLOS
Row filter condition:

IN([keyVuelo],
  SELECT(
    ADUANAS[N VUELO],
    [FECHA]=TODAY()
  )
)

Then, in the [N VUELO] column of the table ADUANAS, the Valid_If expression may be:

PROGRAM VLOS[keyVuelos]- VlosToday_Slice[keyVuelos]

Let us know if that works for you !

3 Likes