alert about no data after days in the text box

[Isabelaa_123]

Hi,

I need create text box, where I have information, which days we have no sale. I need it to verify the correctness of the data.

Example:

We have tables with 3 columns: date, sale and flag (1- sale, 0 - no sale). I tried to write a text box via the if function.

Expected result in textbox: no data: 2022-05-03, 2022-05-05, 2022-05-08

Data	Sales	Flag
2022-05-01	5647,0	1
2022-05-02	736464,0	1
2022-05-03	0,0	0
2022-05-04	7564,0	1
2022-05-05	0,0	0
2022-05-06	4264746,0	1
2022-05-07	6743,0	1
2022-05-08	0,0	0

thank you for any advice 🙂

[smith11484]

check this out :https://stackoverflow.com/questions/8337294/alert-message-on-submit-if-text-box-is-empty-using-php/MyInsuranceInfo

[antose · Accepted solution]

Hi! Try this

='There is '&Count({$<Flag = {0} > } Data)&' days with no sales:'&Chr(10)&Chr(10)&Concat({$<Flag = {0} > } Data, ', ')