Latest Contributions by RogerFarmer1

I am also getting a failure to open the file error for Excel and CSV files. It is an SDE service (not hosted) on Enterprise 10.8.1 with a survey created in Connect 3.12. I tried attaching the files to this post but got a similar error! "Excel cannot open the file 'S123_7c9ce029fb2d4d20a981b5bb4f9cdc0e_EXCEL.xlsx' because the file format or file extension is not valid. Verify that the file format or file has not been corrupted and that the file extension matches the format of the file." ... View more

Hi @Anonymous User , Folder: Internal Storage\DCIM\<sourcefolder> Extension:  .jpg Size: about ranges about 4-9MB ... View more

Hi @Anonymous User , Thank you for the reply. I am following up with the user on the questions you have raised. I also get the impression from the user that they have been successfully attaching images for a few days in a certain way, and then it 'breaks' and they have to find a work-around. (I am trying to get clarification on this). Incidentally, I did crank up S123 field app on Windows with the 'offending' tablet connected via USB to the computer and was successfully able to attach images from the folder that the tablet could not because it displayed them grayed-out. I should explain that the images are captured from a drone being controlled by an iPhone, then the images are downloaded to a laptop, then copied to a folder on the Android tablet, then the images are being attempted to be attached to a survey using the browse method from the folder created by the copy from laptop to tablet process. Cheers, Roger. ... View more

What would be cool is having parameters like the Range question; start, end and step. ... View more

In the end I did this: (round((${input_hours} * 2), 0)) * 0.5 and got this:   ... View more

Hi Phil, Thank you for your help, it is greatly appreciated. The second expression you created worked with the 'or' in the second if statement. It does highlight the clarity needed in question labels, hints, messages and notes! Thanks and regards, Roger ... View more

Hi Phil, I tried it and it hasn't quite worked. The constraint is still applied when both bank1 and bank2 are empty. The above should be OK. The above should also be OK because MEN is no higher than bank2. Regards, Roger ... View more

Thanks, Phil. I'm showing my lack of programming skills, then, by asking how I would write an expression. So far I have come up with: if(${bank1} != NaN, .<= ${bank1}, if(${bank2} != NaN, .<= ${bank2}, '')) Which means: if bank1 is not 'not a number' then constrain to less than or equal to bank1, if bank2 is not 'not a number' then constrain to less than or equal to bank2, else do not constrain. bank1 and bank2 are decimal fields, as is the M.E.N. field. Am I on the right track? Probably not, because I get this: Because both bank1 and bank2 are NaN, any value in MEN should be acceptable. A condition should only be applied if either bank1 or bank2 have a number. Thanks, Roger. ... View more

I used Connect; I can't remember what version. First published to Hosted FS from Connect (not from existing FS) on Aug 13, 2018. It would have been the latest at the time. Roger. ... View more

Thanks for the reply, Phil. Most of the fields available in the FS are available in the survey xlsx form. Certainly the one I would like to use in the survey 123 website are in the form. Roger. ... View more