Looking for Excel macro files alternatives for tablets
Hi, Recently, I created Excel files with macros on Windows in order to be completed by people. It has all features I need : protection, data verification, full protection after data completion and saving in the correct folder. I have been asked : Is it working on Mac and on tablets ? The answer found is : macros cannot be executed on Android and IOS, and they need modifications to be run successfully on Mac (I take the simple case of the paths). In the case of investing money in tablets to be used easily, Android and IOS, according to your experience, what is the best way to have people completing data with the requirements (see below) ? My preference goes to Excel as data can be used for graphics and data analysis, unfortunately Excel macro files cannot be used on tablets... I am opened to other applications and softwares. Requirements : people can enter data and correct it without modifying the document after completing yes to the question : Data are complete ? Data cannot be modified Data can be modified only by authorized people only Data can be viewed by everybody It needs to be usable offline, in case of internet disruption Data completed may be assessed directly when entered (for example a person has written 10 and the number is maximum 8, a "non-conform" in red appears) Thank you for your answers