Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount! Get 20% off now with code SPOOKY-2024!

Invoice Address Fields

11 years 9 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: 48454
  • Thanks: 8280
  • Karma: 1443
11 years 9 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.

11 years 9 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: 48454
  • Thanks: 8280
  • Karma: 1443
11 years 9 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.

11 years 9 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.

11 years 9 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