This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Getting data in Google Sheet

Posted 2 weeks ago
DME1
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Hi, I have created an inventory app sheet where I have updated the inbound and outbound entries. However, I used virtual columns for the "In" and "Out" quantities, which is causing me to miss data in Google Sheets for analysis purposes. How can I resolve this issue?

0 2 71
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Julie-W
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

I'm not sure what you're using those Virtual Columns for, but VCs are entirely internal to Appsheet, so if you want the values to be reflected in Google Sheets, you'll need to create a real column for them in Google Sheets, and use a different way to populate them.  

Posted on --/--/---- --:-- AM
DME1
Bronze 3
Bronze 3
In response to Julie-W
Reply posted on --/--/---- --:-- AM

It is not showing real-time data. If I want real-time data, I need to open and save again to see the live quantity data.

0 Likes