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
LinkedIn
Twitter
