Hello Community, I’ve a date column in SQL table which is in (int) format yyyymmdd. I want to convert this to dd/mm/yyyy in a virtual column? Could you please let me know how I can achieve this. Thanks

Hi. I’ve created a database in my computer using SQL Management Studio. I’m now trying to add this as a data source to my account but I’m not able to get it right. The SQL Server is open for remote connections and I even put in a new Inbound firewall...

Hi. I’m planning on creating a rostering feature to an existing application. However, I can’t seem to get my head around it as to how to achieve this. Obviously, adding one person at a time for each single day is time taking process. So was wondering...

Hi. I’ve a form in which on of the field takes Ref from another table as a list and displays them as a drop down for the user to select. I’ve added the following formula in ‘Valid_if’ so that the drop down contains only ‘Available’ devices. Select(De...

Hi. I’m creating an app for my store which would keep track of my sales and stock levels. At the moment, I’m using it to scan the barcode to add and sell stock and would like help with the following if possible. I’ve a spreadsheet with a list of hand...