Method:Classic General Q&A

Re: Autofilled

Method_Justin — Fri, 12 Dec 2014 19:09:00 GMT

Hi Marcelo,

If you want to add Team Leader to a report based off of the Activity table, you'll first want to add it as a Linked Field to the Activity table, using the Customer table.

Link Using: Entity
Linked Field: TeamLeader

It should be possible to link this field through the Entity (Customer/Employee/Vendor/OtherName) table since you already linked it in there from the TeamMembers table. After doing this, you should see it in the Report Designer as a selectable field in the Activity table.

If you're really stuck, perhaps you should consider our Professional Services team. Let me know if you'd like to go that route.

- Justin

Re: Autofilled

Marcelo11756 — Thu, 11 Dec 2014 16:33:49 GMT

I thought that I linked the two table but i think I did it wrong

Re: Autofilled

Method_Justin — Thu, 11 Dec 2014 16:14:14 GMT

Hi Marcelo,

How did you add the field to the report? We added the field to the Customer table, but you're saying your report is based of the Activity table. I'm curious how you went about adding this field.

Let me know.

- Justin

Re: Autofilled

Marcelo11756 — Thu, 11 Dec 2014 11:25:00 GMT

Print, is a template based on the activities table called Renewal Letter, I though that by putting the field that we inserted the action result to, that would work. But it does not show

Re: Autofilled

Method_Justin — Wed, 10 Dec 2014 14:36:09 GMT

Good morning Marcelo,

Could you elaborate on which type of template you're referring to? Email or Print?

- Justin

Re: Autofilled

Marcelo11756 — Tue, 09 Dec 2014 22:51:53 GMT

The linked field I created is called "ML_CrewLeader2" , when I use this field in my templates nothing shows, why?

Re: Autofilled

Marcelo11756 — Tue, 09 Dec 2014 22:27:32 GMT

The linked field works perfect

Thanks !!!

Re: Autofilled

Method_Justin — Tue, 09 Dec 2014 21:34:57 GMT

Marcelo,

This is how I set my Customer table up to work with this:

Add a New Field:

Field name: Team
Field Type: Dropdown
Click Add Field

Select Choose from an existing Table and click Next
Select the table: TeamMembers
Choose a text field containing the choices: TeamName
Click Finish

Add a New Field:

Field name: TeamLeader
Field Type: Dropdown
Click Add Field

Select Choose from an existing Table and click Next
Select the table: Users
Choose a text field containing the choices: UserName
Click Finish

This setup will auto-populate your Team Leader dropdown with the selected Team's Leader, but will allow you to change it to any user in your system and save it on a per customer basis. It would be useful if you wanted to pick a Team Leader that does not necessarily correlate with the specified Team's actual Leader. This setup will not auto-update your customers with new Team Leaders if you change a Team's Leader in the TeamMembers table.

If you would like to have the Team Leader auto-update for your Customers when you change it in the TeamMembers table, you would want to use a Linked Field for the TeamLeader field instead of a dropdown. If you do this, you will not be able to change the Team Leader on the Edit Customer screen, you will have to change the Team Leader for the whole Team in the TeamMembers table. Here's how to add the fields to your Customer table to get it to work this way:

Add a New Field:

Field name: Team
Field Type: Dropdown
Click Add Field

Select Choose from an existing Table and click Next
Select the table: TeamMembers
Choose a text field containing the choices: TeamName
Click Finish

Add a Linked Field:

Link Using: Team
Linked Field: TeamLeaderUser
Display As: TeamLeader
Click Add Field

Then, you'll want to set up your Text Change actions for the Team dropdown like this (I've underlined any changes I made from my first reply):

Select the Text Change event from the dropdown and select the Retrieve Value from Screen action, click Add Action:

Select value: Team (this will be whatever your Team dropdown is named)
Dropdown Attribute: Value (RecordID)
Action Result name: I named mine ARTeamID
Click Save & Close

Select the Text Change event from the dropdown and select the Retrieve Value from Table action, click Add Action:

From Table: TeamMembers
From Field: TeamLeaderUser
Where Field: RecordID
value is: Action Result
ARTeamID (whatever you named your Action Result from earlier)
Place value in: Action Result
I named mine ARTLUser
Click Save & Close

Select the Text Change event from the dropdown and select the Enter Value Into Field On Screen action, click Add Action:

Update field or object: Team Leader
With the Value: Action Result
ARTLUser (whatever you named your second Action Result)
Click Save & Close

I also made the Team Leader field on the screen Read Only, since it's a Linked Field and cannot be changed on the database level anyway
Click Finish, then Publish and Save & Close the designer

Let me know if that works for you.

- Justin

Re: Autofilled

Marcelo11756 — Tue, 09 Dec 2014 21:00:39 GMT

Finally I made it work, I was putting the action result into a text box and not a field from the customer table.

So my only question is what happens when I change a team leader in one of my teams?

Re: Autofilled

Marcelo11756 — Tue, 09 Dec 2014 20:37:41 GMT

I gave up, not working properly

When I select the crew and save, it is fine but it saves the same crew leader for all customers

Re: Autofilled

Marcelo11756 — Tue, 09 Dec 2014 20:25:01 GMT

Never mind is working now.

But, what would happen if I make changes in my teams, for example one od the team has a new team leader , will the field be updated ?

Re: Autofilled

Marcelo11756 — Tue, 09 Dec 2014 20:18:04 GMT

Is not working for me, I think it may have to do with the way my teams are created

Can't make it work

Re: Autofilled

Method_Justin — Tue, 09 Dec 2014 18:16:18 GMT

Hi Marcelo,

You should be able to do this using some Actions for the Text Change event on your Teams dropdown.

From the screen designer, click Edit for the dropdown containing your Teams and Click Next to go to Step 2 of 6.

Select the Text Change event from the dropdown and select the Retrieve Value from Screen action, click Add Action:

Select value: Team (this will be whatever your Team dropdown is named)
Dropdown Attribute: Value (RecordID)
Action Result name: I named mine ARTeamID
Click Save & Close

Select the Text Change event from the dropdown and select the Retrieve Value from Table action, click Add Action:

From Table: TeamMembers
From Field: TeamLeaderUser_RecordID
Where Field: RecordID
value is: Action Result
ARTeamID (whatever you named your Action Result from earlier)
Place value in: Action Result
I named mine ARTLUserID
Click Save & Close

Select the Text Change event from the dropdown and select the Enter Value Into Field On Screen action, click Add Action:

Update field or object: Team Leader
Dropdown Attribute: Value (RecordID)
With the Value: Action Result
ARTLUserID (whatever you named your second Action Result)
Click Save & Close

Click Finish, then Publish and Save & Close the designer

That should do the trick.

Hope this helps.

- Justin

Autofilled

Marcelo11756 — Tue, 09 Dec 2014 14:35:41 GMT

I have a field in my customer screen called "crew leader", I want this to be autofilled when I select the team for that customer (a dropdown field showing all the differents team)

How can I do this?