Latest Contributions by PanGIS

Thank you @TonghuiMing  I probably did not realize that until I got over 20 sites and this happened at the same time as the AGOL update. My client is not going to be happy... 😑 I need to find an alternative. Thanks again! ... View more

Hi! Does this happen with all maps? Are this maps  yours or they are shared with you?   ... View more

Hi @IsmaelChivite  it works! ❤️   I believe there shouldn't be any issue as the survey is internal within the Organization and it requires login. The lack of internet is not listed as limitation, so it can be saved in the Outbox without problems!   Thank you!!!   ... View more

Hello @IsmaelChivite and @JamesTedrick , sorry for tagging you but I am desperate. 😓   I need to find a way to calculate a date that is always next month, always on the same day of the month,  (let's say the 15th of the following month). if I submit the survey today, the calculated date is the 15th of February. If I submit on any day in February, that calculated day will be the 15th of March.   I found a way to calculate it but I need to change the date every month and this in not going to be possible. My attempts, the first works but I have to change it manually every month, the other two are failed attempts: https://www.dropbox.com/s/54kfbvtvg9i942q/test_Date.xlsx?dl=0   ... View more

@JayantaPoddar  in case you have 5 minutes to spare, here attached a xls with three samples. The first one is the one that works.   Thanks! ... View more

Thank you @JayantaPoddar  You got exactly what I need but I am struggling with the function. is that "eomonth" function supported?   If I replace with this:    if(1=1, 'EOMONTH(TODAY(),0)+1', if(1=0, '0000-00-00','1111-11-11'))     The calculation results in a string: 'EOMONTH(TODAY(),0)+1' not a date this means that when I try to add 24 days to my date field field I get an error. (also tried to bind the field as date but nothing).   I also tried the following, instead of the previous string: date(decimal-date-time(eomonth(${inspection_Date},0)+1)) , not sure if it make sense, but I get a error in calculating the expression. I am attaching the xls as soon as I get back to my desk. ... View more

Hi @ZacharySutherby ,   thank you for your reply. The date in that field is created only once and it never changes. The record is an inspection that will be updated with other surveys but that Date field stays the same until the case is closed (the case is closed when that date passes).   If today, or any day of this month, I run an inspection, the date recorded in that field is the 25th of February. For any inspection run in February, the date recorded in that field is the 25th of March. (the date in my screenshot is updated already for the inspections of February) ... View more

Thank you @TonghuiMing , it make sense. I was only afraid to have messed up with the trigger. Today I demonstrated the functionality of the app and nobody complained. 😅   I will che if I can get something better with other widgets but it is fine for now. Cheers! ... View more