# Google Sheets Collaboration

**Google Sheet** users who want to share runtime files with other users and use runtime files can do so without any difficulty. However, there are a few technical considerations to keep in mind when collaborating on shared runtime files.

When a runtime file is shared with other users in **Google Sheets**, it allows them to access the same file and make necessary changes. However, it's important to note that when single or multiple users collaborate on a shared file, users may notice latency in rendering the [**Form Map**](https://docs.valorx.com/valorx-fusion/design-studio/maps/form-map) compared to the original file that was initially shared.

This latency in rendering the **Form Map** during collaboration is due to the APIs used to run the shared file.

{% hint style="info" %}
The file owner typically uses "[**batchupdate**](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdate)" and "[**batchclear**](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchClear)" methods, while the shared file utilizes "[**setValue(value)**](https://developers.google.com/apps-script/reference/spreadsheet/range#setValue\(Object\))" method.
{% endhint %}

Follow the below simple steps to share a file with other users.

* Open the runtime file in **Google Sheets**.
* Select **File** and click **Share** button and select "**Share with Others**".

<div align="left"><figure><img src="https://2472585788-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFqFFf4143HS0_Wagnz%2Fuploads%2Fr0U62PjVTirEn9td74Qf%2FGsheets%20Collab.png?alt=media&#x26;token=a634d9f3-f7a6-4098-881c-1a1de78e0832" alt="" width="536"><figcaption></figcaption></figure></div>

* Provide the email address of the user to whom it needs to be shared under "**Add people or groups**".
* Click **Done**.
* Once the file is shared it will be saved in **Google Drive** of the user receiving the file.

<div align="left"><figure><img src="https://2472585788-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFqFFf4143HS0_Wagnz%2Fuploads%2FcZ11De8lPMtRy4eGl3aj%2FGsheets%20Collab%202.png?alt=media&#x26;token=4e21849e-8984-4cc1-9443-eb08dac18898" alt="" width="465"><figcaption></figcaption></figure></div>

Here, are a few messages which Users may encounter when there is no active connection or when they are connected to a different org, and when a fresh copy of the runtime file needs to be opened.

* When a file is shared, and the User does not have the **Active Connection** (**comparing the owner of the file and the currently logged-in user**) a message will be shown to connect to that org to access the App Menu.

<div align="left"><figure><img src="https://2472585788-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFqFFf4143HS0_Wagnz%2Fuploads%2FV0hK6Xg5tE9nKgzJ4nfY%2FActive.png?alt=media&#x26;token=ad3d9d32-702c-4688-95b3-8c013ecbd634" alt="" width="276"><figcaption></figcaption></figure></div>

* Users will receive a message to connect to that org to access app menus when the active connection is different from the org.

<div align="left"><figure><img src="https://2472585788-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFqFFf4143HS0_Wagnz%2Fuploads%2FGg0iLoJMt9grIsq4FbXR%2FNo%20connection.png?alt=media&#x26;token=d57999bd-ebf5-44f5-94a3-93f3355f47f6" alt="" width="272"><figcaption></figcaption></figure></div>

* In case you're trying to open a saved runtime file in Google Drive, and you're not the owner of the file, a warning message may pop up asking you to open a fresh copy of the runtime file. This is because the owner of the file might have made changes to the runtime file after it was last saved, and opening a fresh copy ensures that the user is accessing the most up-to-date version of the runtime file.

<div align="left"><figure><img src="https://2472585788-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFqFFf4143HS0_Wagnz%2Fuploads%2FGKDbbfNJsTQk8BJW74DF%2FApp%20modified.png?alt=media&#x26;token=0bfcf9f8-bc1d-4759-a30e-62df0b82cc07" alt="" width="275"><figcaption></figcaption></figure></div>

To ensure smooth collaboration and usage of runtime files in **Google Sheets**, it's important for users to be aware of these considerations.