How to SetAddress when in a contact with no existing address
up vote
0
down vote
favorite
I am trying to update or add an Address in my contacts using a value in Google Sheet.
I am using this code (where address is the value in Google Sheet):
var AddressFields = contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS);
AddressFields[i].setAddress(address);
It works when the contact I am trying to update has an Address field labeled HOME_ADDRESS.
But it does not work if the Address is labeled differently (WORK_ADDRESS for example) or if there is no existing Address
I tried to use the setLabel function to create an Address placeholder but it does not seems to work.
var addressFields = contacts[i].getAddresses();
addressFields[i].setLabel(ContactsApp.Field.HOME_ADDRESS);
Do you know how I could make sure it works in any situation?
Thanks a lot for your help
contacts google-contacts
add a comment |
up vote
0
down vote
favorite
I am trying to update or add an Address in my contacts using a value in Google Sheet.
I am using this code (where address is the value in Google Sheet):
var AddressFields = contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS);
AddressFields[i].setAddress(address);
It works when the contact I am trying to update has an Address field labeled HOME_ADDRESS.
But it does not work if the Address is labeled differently (WORK_ADDRESS for example) or if there is no existing Address
I tried to use the setLabel function to create an Address placeholder but it does not seems to work.
var addressFields = contacts[i].getAddresses();
addressFields[i].setLabel(ContactsApp.Field.HOME_ADDRESS);
Do you know how I could make sure it works in any situation?
Thanks a lot for your help
contacts google-contacts
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am trying to update or add an Address in my contacts using a value in Google Sheet.
I am using this code (where address is the value in Google Sheet):
var AddressFields = contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS);
AddressFields[i].setAddress(address);
It works when the contact I am trying to update has an Address field labeled HOME_ADDRESS.
But it does not work if the Address is labeled differently (WORK_ADDRESS for example) or if there is no existing Address
I tried to use the setLabel function to create an Address placeholder but it does not seems to work.
var addressFields = contacts[i].getAddresses();
addressFields[i].setLabel(ContactsApp.Field.HOME_ADDRESS);
Do you know how I could make sure it works in any situation?
Thanks a lot for your help
contacts google-contacts
I am trying to update or add an Address in my contacts using a value in Google Sheet.
I am using this code (where address is the value in Google Sheet):
var AddressFields = contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS);
AddressFields[i].setAddress(address);
It works when the contact I am trying to update has an Address field labeled HOME_ADDRESS.
But it does not work if the Address is labeled differently (WORK_ADDRESS for example) or if there is no existing Address
I tried to use the setLabel function to create an Address placeholder but it does not seems to work.
var addressFields = contacts[i].getAddresses();
addressFields[i].setLabel(ContactsApp.Field.HOME_ADDRESS);
Do you know how I could make sure it works in any situation?
Thanks a lot for your help
contacts google-contacts
contacts google-contacts
asked Nov 19 at 16:15
Charlie
11
11
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
How about using nested-if? For example:
for (var i = 0; i < n; i++ {
if (contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS)) {
address = contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS;
} else if (contacts[i].getAddresses(ContactsApp.Field.WORK_ADDRESS)) {
address = contacts[i].getAddresses(ContactsApp.Field.WORK_ADDRESS);
} else {
address = '';
}
AddressFields[i].setAddress(address);
}
I think what you are proposing is actually getting the address from Google contacts right? My issue is to find which Address field exists in Google contact and fill this with a value from a Google Sheet. At the moment, if I am trying to fill the Home_Address but there is no address field labeled Home_Address, my script fails.
– Charlie
Nov 20 at 15:04
The idea was to check whetherHOME_ADDRESS
exists, if not, check if there is aWORK_ADDRESS
. If all else fails, set to empty, so that at least there will be a fallback if there are no addresses available. I only tried to replicate this in a simple js file, so I'm not really sure how it would have been implemented on your case.
– Jacque
Nov 20 at 23:32
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
How about using nested-if? For example:
for (var i = 0; i < n; i++ {
if (contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS)) {
address = contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS;
} else if (contacts[i].getAddresses(ContactsApp.Field.WORK_ADDRESS)) {
address = contacts[i].getAddresses(ContactsApp.Field.WORK_ADDRESS);
} else {
address = '';
}
AddressFields[i].setAddress(address);
}
I think what you are proposing is actually getting the address from Google contacts right? My issue is to find which Address field exists in Google contact and fill this with a value from a Google Sheet. At the moment, if I am trying to fill the Home_Address but there is no address field labeled Home_Address, my script fails.
– Charlie
Nov 20 at 15:04
The idea was to check whetherHOME_ADDRESS
exists, if not, check if there is aWORK_ADDRESS
. If all else fails, set to empty, so that at least there will be a fallback if there are no addresses available. I only tried to replicate this in a simple js file, so I'm not really sure how it would have been implemented on your case.
– Jacque
Nov 20 at 23:32
add a comment |
up vote
0
down vote
How about using nested-if? For example:
for (var i = 0; i < n; i++ {
if (contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS)) {
address = contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS;
} else if (contacts[i].getAddresses(ContactsApp.Field.WORK_ADDRESS)) {
address = contacts[i].getAddresses(ContactsApp.Field.WORK_ADDRESS);
} else {
address = '';
}
AddressFields[i].setAddress(address);
}
I think what you are proposing is actually getting the address from Google contacts right? My issue is to find which Address field exists in Google contact and fill this with a value from a Google Sheet. At the moment, if I am trying to fill the Home_Address but there is no address field labeled Home_Address, my script fails.
– Charlie
Nov 20 at 15:04
The idea was to check whetherHOME_ADDRESS
exists, if not, check if there is aWORK_ADDRESS
. If all else fails, set to empty, so that at least there will be a fallback if there are no addresses available. I only tried to replicate this in a simple js file, so I'm not really sure how it would have been implemented on your case.
– Jacque
Nov 20 at 23:32
add a comment |
up vote
0
down vote
up vote
0
down vote
How about using nested-if? For example:
for (var i = 0; i < n; i++ {
if (contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS)) {
address = contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS;
} else if (contacts[i].getAddresses(ContactsApp.Field.WORK_ADDRESS)) {
address = contacts[i].getAddresses(ContactsApp.Field.WORK_ADDRESS);
} else {
address = '';
}
AddressFields[i].setAddress(address);
}
How about using nested-if? For example:
for (var i = 0; i < n; i++ {
if (contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS)) {
address = contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS;
} else if (contacts[i].getAddresses(ContactsApp.Field.WORK_ADDRESS)) {
address = contacts[i].getAddresses(ContactsApp.Field.WORK_ADDRESS);
} else {
address = '';
}
AddressFields[i].setAddress(address);
}
answered Nov 20 at 11:10
Jacque
2066
2066
I think what you are proposing is actually getting the address from Google contacts right? My issue is to find which Address field exists in Google contact and fill this with a value from a Google Sheet. At the moment, if I am trying to fill the Home_Address but there is no address field labeled Home_Address, my script fails.
– Charlie
Nov 20 at 15:04
The idea was to check whetherHOME_ADDRESS
exists, if not, check if there is aWORK_ADDRESS
. If all else fails, set to empty, so that at least there will be a fallback if there are no addresses available. I only tried to replicate this in a simple js file, so I'm not really sure how it would have been implemented on your case.
– Jacque
Nov 20 at 23:32
add a comment |
I think what you are proposing is actually getting the address from Google contacts right? My issue is to find which Address field exists in Google contact and fill this with a value from a Google Sheet. At the moment, if I am trying to fill the Home_Address but there is no address field labeled Home_Address, my script fails.
– Charlie
Nov 20 at 15:04
The idea was to check whetherHOME_ADDRESS
exists, if not, check if there is aWORK_ADDRESS
. If all else fails, set to empty, so that at least there will be a fallback if there are no addresses available. I only tried to replicate this in a simple js file, so I'm not really sure how it would have been implemented on your case.
– Jacque
Nov 20 at 23:32
I think what you are proposing is actually getting the address from Google contacts right? My issue is to find which Address field exists in Google contact and fill this with a value from a Google Sheet. At the moment, if I am trying to fill the Home_Address but there is no address field labeled Home_Address, my script fails.
– Charlie
Nov 20 at 15:04
I think what you are proposing is actually getting the address from Google contacts right? My issue is to find which Address field exists in Google contact and fill this with a value from a Google Sheet. At the moment, if I am trying to fill the Home_Address but there is no address field labeled Home_Address, my script fails.
– Charlie
Nov 20 at 15:04
The idea was to check whether
HOME_ADDRESS
exists, if not, check if there is a WORK_ADDRESS
. If all else fails, set to empty, so that at least there will be a fallback if there are no addresses available. I only tried to replicate this in a simple js file, so I'm not really sure how it would have been implemented on your case.– Jacque
Nov 20 at 23:32
The idea was to check whether
HOME_ADDRESS
exists, if not, check if there is a WORK_ADDRESS
. If all else fails, set to empty, so that at least there will be a fallback if there are no addresses available. I only tried to replicate this in a simple js file, so I'm not really sure how it would have been implemented on your case.– Jacque
Nov 20 at 23:32
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53378716%2fhow-to-setaddress-when-in-a-contact-with-no-existing-address%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown