Skip to Content Skip to Menu

Invoice Address Fields

12 years 10 months ago #218905 by techbranchsm
Invoice Address Fields was created by techbranchsm
Is it possible to put the Invoice address information in the "Contact Info" Tab?

I don't see those fields in the field management section but when a user goes to pay it allows them to fill in there. I would like the users to be able to edit this in there profile as well as during registration.

Company:
Address:
City:
Zipcode:
Country:
Phone:

Thanks

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 49754
  • Thanks: 8506
  • Karma: 1465
12 years 10 months ago #218919 by krileon
Replied by krileon on topic Re: Invoice Address Fields
You can try substituting them in a delimiter field, but if that doesn't work you'll need to use a CB Query Field. Substitutions as follows.

[cb_subs_inv_first_name]
[cb_subs_inv_last_name]
[cb_subs_inv_payer_business_name]
[cb_subs_inv_address_street]
[cb_subs_inv_address_city]
[cb_subs_inv_address_state]
[cb_subs_inv_address_zip]
[cb_subs_inv_address_country]
[cb_subs_inv_contact_phone]
[cb_subs_inv_vat_number]

Example CB Query Field usage as follows.
Code:
SELECT `cb_subs_inv_address_street` FROM `#__comprofiler` WHERE `user_id` = '[user_id]'


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

12 years 10 months ago #218927 by techbranchsm
Replied by techbranchsm on topic Re: Invoice Address Fields
The delimiter field didn't work but the DB lookup did. Do I have to also provide code for the Query update and the rollback update?
If so, what should I put in there for the cb_subs_inv_address_street ??

Right now the default has testcodes in it.

Thanks for your help.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 49754
  • Thanks: 8506
  • Karma: 1465
12 years 10 months ago #218929 by krileon
Replied by krileon on topic Re: Invoice Address Fields
Update? Rollback? I don't understand. You'd use CB Query Field. Not CB DB Lookup Field. You just need to do a select query as shown in my previous post to output the database column for that user.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

12 years 10 months ago #218934 by techbranchsm
Replied by techbranchsm on topic Re: Invoice Address Fields
I guess I am confused. I want the user to be able to update his cb_subs_address_street in the Contact Info tab and it already be on the cb_subs_inv_address_street and visa versa

Please Log in or Create an account to join the conversation.

12 years 10 months ago #218937 by techbranchsm
Replied by techbranchsm on topic Re: Invoice Address Fields
Oh, wait i get it... the CB Query Field.. let me try that : )

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum