Modify values

            Maintaining accurate and up-to-date spreadsheet data is crucial for the reliability of your documents. The application provides an efficient way to make changes to your spreadsheet data. This article outlines the steps required to make these modifications within the application.

Method 1: Updating Spreadsheet Data via Spreadsheet Layer

      1. Begin by selecting the appropriate entity and document from the document process screen.

      2. Click on the Spreadsheet Layer icon and you will be redirected to the Spreadsheet layer.

     

      3. Then, choose the required spreadsheet in the Spreadsheet Layer and double-click to open it. 

      4. You can now proceed to make the necessary data modifications in the spreadsheet. 

      5. Once the modifications are complete, click "Save" to apply the modifications. 

      6. Click the "Close" button to exit the spreadsheet and return to the Home screen of the Spreadsheet layer.

Method 2: Updating Spreadsheet Data via Content Layer

      1. Choose the required entity and document in the document process screen.

      2. Click on the "Content Layer" icon to navigate to the document where the spreadsheet is linked.

      3. Next, click on the "Spreadsheet" icon and choose the required spreadsheet.

      4. Update the data in the spreadsheet as required.

      5. Click the "Save" icon to confirm the changes. 

      6. Click the "Close" button to automatically save the changes. This completes the modification process.

            By following these steps, you can ensure that your spreadsheet data remains accurate and current.

• Related Articles

• Update linked values

  The process of updating values from spreadsheet which are linked to the documents plays a vital role. The application offers intuitive methods to seamlessly update the document with revised data from one or more spreadsheets. This article outlines ...

• Modify values in the spreadsheet offline and reupload

  Keeping your spreadsheet data up-to-date is crucial for ensuring accurate and reliable information in your documents. Whether you need to make major or minor changes, the application provides a seamless way to modify and update your spreadsheet data. ...

• Spreadsheet Layer

  The Spreadsheet feature in Rainbow enables effortless integration of your source data residing in spreadsheets with the document in the application. Any modifications made to the integrated spreadsheet can be synchronized with the corresponding ...

• Create or update user role

  Proper role assignment enables users to access necessary tools and functionalities, thereby enhancing productivity. This guide provides step-by-step instructions on how to set up and update user roles, focusing on granting access to the spreadsheet ...

• Link spreadsheet data with the document

  Once data is imported into the application either by uploading a spreadsheet or creating a new spreadsheet, it can then be linked to the document available in the content layer. Follow the steps outlined below to effectively link data: To begin, ...

• Popular Articles

• Sign in to the Rainbow application

  You can log in to the Rainbow application with the credentials (registered email address and password) shared by us. To access the login page, use the following URL: rainbow.datatracks.com Enter your registered email address and password. Click on ...

• Create entity

  An "Entity" is a term used to describe a company that's required to create and submit periodic reports to regulatory authorities in iXBRL format. It's important to note that a single firm can have multiple entities under its umbrella. To uniquely ...

• Create user

  A "User" refers to a specifically identified individual who plays a role in preparing, reviewing, and filing documents. Follow the provided steps below to create a user. Admin >> User >> Add >> Submit Hover the mouse over the “Admin” menu at the top ...

• Edit user

  In case you would like to modify the user details, you can change them by following the provided steps below. Admin >> User >> Edit >> Submit. 1. Hover the mouse over the “Admin” menu at the top right of your screen then select "User" to access and ...

• Create user role

  A "user role" is a defined set of permissions and privileges assigned to a user within the application. These roles are created to determine what actions a user can perform, what information they can access, and what functions they can execute within ...

• Recent Articles

• Audit Trail

  The Audit Trail feature allows administrators to track and monitor activities performed by users within the application. This section is can access only by the Admin. Click on the "Audit Trail" section in the application to access the activity log. ...

• Edit user

  In the MTD VAT application, you can easily update a user’s details, including their name, role, and permissions. You also have the option to assign an entity or revoke authorisation if needed. Follow the steps below to edit user details effectively. ...

• License Renewal

  If your MTD VAT application licence has expired, there is no need to worry. Renewing your licence is a straightforward process that ensures uninterrupted access to your services. Follow the steps below. Steps to Upgrade or Renew Your Licence 1. ...

• Status Forbidden

  While creating an MTD VAT return, you may encounter a "Forbidden" status. This typically occurs due to incorrect login credentials or authorisation issues with HMRC. To resolve this, ensure that you are using the correct credentials assigned to the ...

• Status is Unauthorized

  While creating an MTD VAT return, you may receive a "Unauthorised" status. This typically occurs when HMRC’s authorisation (OAuth token) has expired, preventing the application from successfully interacting with HMRC. To resolve this issue, you need ...