Date Picker / Google Calendar & Sheets default selections

[Champ23]

My app is integrated with Google Calendar and Sheets. When I add events or edit events within the app, the date picker defaults to Datetime of now when used on the web app, however on my iOS device app it shows the correct data. I have datetimes that are either nested in a Google Sheet or from the Google Calendar event itself and it always works as intended on the iOS devices but not on the web.

The only thing I have found online is Localization settings and I've made sure that Google Sheets, Google calendar are both showing Central time (CST). However google sheets shows CST as GMT-6 hours and Google calendar shows CST as GMT-5. I've also made the computer system setting identical to the format of the desired datetime. 

I cannot figure out any localization settings in AppsSheet that could help me. Any ideas to make the webapp show the data in the edit screen correctly?

iOS date picker showing correctlyweb app of same event not showing any date and defaults to now when selected.

[WillowMobileSys]

Is the iOS version showing an existing row that you selected to be edited?  If so, are you certain your web page is performing the same functionality?

[Champ23]

I'm confused on the question. How would the webpage perform differently? Is there a way to have IOS and web show different things based on the viewer?

[WillowMobileSys]

---

@Champ23 wrote:

I'm confused on the question. How would the webpage perform differently?

---

I guess a clarification is order.  "Webpage" could refer to 2 different things:

1. The Browser version of the web app
2. A separate business or personal web site that has a page with an Appsheet app embedded into it - such as with an iFrame component.

Originally I was thinking you were referring your own webpage.  I am now thinking, based on your confusion, you meant the Browser version of the app.

I then also suspect you are running the Browser version of the app using the Desktop Mode preview.  Desktop Mode is Beta only right now and should not be used for deployed "live" apps.  It does have issues.

If your app is a deployed "live" app, I then recommend turning OFF the Desktop Mode and reverting back to the legacy Desktop Views.  See image for location of this setting.

I hope this helps!

[Champ23]

Thanks for the reply.  Yes I am referring to the the Browser version of the APP and not an app embedded in a webpage. Unfortunately I am not using the Desktop Mode preview option that you pointed out so that is not the problem. However, I have finally chased down a third computer and it works correctly. 

My problems seems to be the two windows 11 machines either or Chrome or Edge not displaying the date picker correctly. The data always defaults to TimeNow and not the data in the Google Sheet or Google Calendar to change. The iOS device AppSheet app and Apple on chrome using the webapp work correctly. This makes me feel its a localization issues on the windows machines that I just cannot resolve. 

[WillowMobileSys]

---

@Champ23 wrote:

My problems seems to be the two windows 11 machines either or Chrome or Edge not displaying the date picker correctly. The data always defaults to TimeNow and not the data in the Google Sheet or Google Calendar to change.

---

Ok, ruled out Desktop Mode.  If this was a common problem, we would have heard more about it. 

Displaying the wrong date in the Date Picker control doesn't seem to be a Browser problem.  That feels more like an AppSheet app issue.  

You mentioned that the Form shows today's date instead of the date saved with the row.  That sounds like initialization logic has kicked in on a new row instead of opening an existing row for editing.  My hunch is that the operation isn't working like you think it is - that it's opening a new row.  Your screen shots don't prove one way or the other.

Can you you show us:

1. Details on how you are opening a row for editing - including any custom actions you may have implemented? 
2. The date column configuration - specifically the Initial Value and Reset on Edit settings?

[Champ23]

I found an Appsheet templated app that duplicates the issue I'm having. 

https://www.appsheet.com/templates/Events%20Calendar?appGuidString=87fbb744-508e-428e-b6d9-b5fc2b467...

I created a calendar event on this demo app. When I went back to edit the event I created, the same issue I'm having with my app is duplicated here. The start and end times default to TimeNow on the date picker and not the original dates and times I added to the demo app. Works fine on my tablet. 

This makes me believe it is somehow related to my computers/browser location setup and I cannot for the life of me figure out why!

[WillowMobileSys]

I am not seeing an issue.  When I tap the "+" button I get a view like this:

Form for New row defaulted to Today's Date and the time right now

These Date/Time defaults are controlled here:

After changing default Date/Times, I see event entries on Calendar like this.  

After tapping on the "Test 2" event it opens in a Detail view.  The dates and times are showing correctly.

After tapping the Edit button, the Form opens with the existing row and show the correct Dates and Times as previously entered

Where does this go wrong for you?

[Champ23]

I am not getting the same results as you...

This is the screen when I select the + everything is blank and when I open to edit it shows the time of when I make the entry (TIMENOW)

When I chose the +

I am able to enter data and create an event. The data now shows when I enter data.

i'm able to enter the data

Event successfully entered on the calendar

the data saves

After I click on the event prior to editing it

when i click to edit the same event

This is where I see the problem. The dates and time are not appearing in the window and when I select the date picker or time picker it defaults to the current time and not the original time. Unfortunately I cannot figure out how to take a screen shot to show this as the date picker drops off when I select the snipping tool. 

the event that I added does not show the data and time

[Champ23]

Both versions are looking at a datetime already in a cell. See attached image. 

[Champ23]

---

@WillowMobileSys wrote:

• Details on how you are opening a row for editing - including any custom actions you may have implemented? 
• The date column configuration - specifically the Initial Value and Reset on Edit settings?

---

I have a google sheet with two rows. Each row is a different calendar period template.  When added, this data feeds one of two options to Google Calendar to add 8 hour periods. It works flawlessly. I created a virtual column called start time to read the sheets contents because the date picker is essentially blank even though there is data in the column/row. I can then update that row real time on all devices.

However, I also have a google calendar integrated within the app and the Start and End time fields are also doing the same thing as my google sheet. 

Initial Value - Right now this block is blank. I have tried several options to toy with showing the contents in the column to edit. 

Reset on Edit setting - unchecked

Interestingly i'm trying to get the date time to display MM/DD/YYYY HH:MM yet my devices show differently. (see attached images). Google sheets and Calendar are both set to display MM/DD/YYYY HH:MM.

Photos