Multi selection of date column

[NPARSA]

Hi,

I have created an app to get user information.

The data will be populated in Mysql data base. 

We have a column of type date, which currently just allow one date selection.

Is there any functionality in appsheet, that enable user to select multiple dates(arbitary dates) in form view on a same request and then this request inserted into MySQL data base as seperate rows which has all the field the same except the date.

[Steve]

There is no built-in functionality to do what you want.

[NPARSA]

Thanks for your prompt respond

[NPARSA]

Is there ant way I can implement it?

[Steve]

I can imagine a few possible approaches. My suggestion would be to make a column of type EnumList with a base type of Date. Expose this column in the form to allow the user to choose multiple dates. Use a Form Saved event action for the form view to add rows to accommodate each of the dates in the EnumList. Move one date of the EnumList into each of the new rows.

FAQ: add row per value in EnumList - Google Cloud Community

[NPARSA]

Thanks very much, really appriciate it