# How to save company details from a user to an object

**URL:** <https://community.blippa.com/t/how-to-save-company-details-from-a-user-to-an-object/67>\
**Category:** Uncategorized\
**Tags:** variables\
**Created:** [October 11, 2022, 9:47am UTC](https://community.blippa.com/t/how-to-save-company-details-from-a-user-to-an-object/67 "2022-10-11T09:47:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrunhem](https://community.blippa.com/letter_avatar_proxy/v4/letter/m/919ad9/32.png) [@mrunhem](https://community.blippa.com/u/mrunhem)\
**Post date:** [October 11, 2022, 9:47am UTC](https://community.blippa.com/t/how-to-save-company-details-from-a-user-to-an-object/67/1 "2022-10-11T09:47:02Z")

</div>

Usecase:  
MAUS is a supplier of fire extinguisher modules for electrical installations.  
The modules are installed by certified installers.  
The request was to have the company contact details visible on the Blippa pages.

Solutions that were dismissed:

- The approach to have the user to enter the company details for every label activation was to clumsy/time consuming.
- One solution was to add an account variable but that could only host plain text. And creating one variable for street address, another for phone number etc was also clumsy.

Solution:  
We created an Google Sheet, containing the MAUS partner companies and their information.  
Since the companies had branch offices, we added one key column to separate the branches.  
 ![Screenshot 2022-10-11 at 11.29.11](https://community.blippa.com/uploads/default/original/1X/6572f1c0d6b720c339e100fc021254e90c4ac738.png)

Then, we added the Google Sheet as a Data Source in the Blippa Labelsadmin:

 ![Screenshot 2022-10-11 at 11.30.33](https://community.blippa.com/uploads/default/original/1X/8f1feea27a7e8c2c95fd24ef7bc70ad119e9dadf.png)

Then, we created an Account _Profile_ Variable named Partner and connected that to the new data source.  
Note: Select “Account Profile” to make this variable “stick” to the user profile.

 ![Screenshot 2022-10-11 at 11.35.52](https://community.blippa.com/uploads/default/original/1X/c4825eed63fb3a2ffdbf2a34572a3b3615bd66e8.png)

Then, we created one invite link/QR code for each partner company and used our brand new “Set Profile Variable” setting to map each invite to the corresponding partner. This will create an “invisible link” between the user and the partner company&branch. Each user that is created by this invite link will get this variable setting automatically.

 ![Screenshot 2022-10-11 at 11.32.15](https://community.blippa.com/uploads/default/original/1X/aa073748824943bd0dde4427e732e2b53b6c95cc.png)

Then, in the Function block that provides all the buttons to the objects, we added one new variable: Maus Partner and pointed that to the Data Source:

 ![Screenshot 2022-10-11 at 11.44.15](https://community.blippa.com/uploads/default/original/1X/8ffe397c703bfbcfdfeeaebdfb2ac2da014d9f90.png)

Then, in the Activation Template (that is used to create new objects (i.e activate the stickers/labels) we added a Variable setting that pointed Maus Partner to the Partner variable (Read only). This will effectively take the Partner setting from the logged in user (the installer) and copy it to the new object as the value of the Maus Partner variable.  
(If the installer quits his job and starts working at another MAUS partner, the object will still point to the original installation company, not the new one).

 ![Screenshot 2022-10-11 at 11.38.31](https://community.blippa.com/uploads/default/original/1X/d5bf7aa6aef4b52957fa7e48c044828df3a1628c.png)

Now we used the new variables to display the partner contact details in a Blippa page:

 ![Screenshot 2022-10-11 at 12.05.07](https://community.blippa.com/uploads/default/original/1X/28c1e2947d3a2a9a81ca5df5f498c64f62b4e4f2.png)  
_NOTE: Be sure to use the object variable name (in this case MAUS Partner) instead of the Account variable Partner. The later will point to the installers current setting and will not work over time…_

And the final result:

 ![Screenshot 2022-10-11 at 12.04.14](https://community.blippa.com/uploads/default/original/1X/b08a1a59f41c60c27971c20b6652f3f9310f6d6c.png)

_Sorry for the looong and complicated post but I needed to document this for my own memory 🙂_
