Migrating from Excel to MS SQL Server - Yes/No field

Kwan
Participant II

I am migrating my app from using Excel as a data source to using MS SQL Server. I noticed that when i migrate the existing data on Yes/No fields they go in as TRUE or FALSE, but when I add/edit these fields when using the database they change to 1 or 0. I am concerned, because I have written expressions in the app that reference TRUE and FALSE and are wondering if they will still work or not. I am thinking my options are to either change the AppSheet field from Yes/No to text or find all my expressions that reference TRUE or FALSE and update them. Any ideas on how to make this easier or if this isnโ€™t an issue would be appreciated. Thanks. Kevin

0 2 242
2 REPLIES 2

AppSheet supports all of the Boolean representations interchangeably - โ€œYesโ€/โ€œNoโ€, โ€œTrueโ€/โ€œFalseโ€, โ€œtrueโ€/โ€œfalseโ€, โ€œYโ€/โ€œNโ€, โ€œ0โ€/โ€œ1โ€

So I donโ€™t think yo need to change anything.

Thanks for your help John! Kevin

Top Labels in this Space