Set a line field to a header field when I "Add line".

(0) Share

Report

Posted on by Dushatar

Hello.

Im new to Dynamics and this is probably really simple but I cant get it to work.

When I Add a new line Id like some of the fields to be automatically filled in. For example I want to copy a value from the header into a field on the new line.

I tried to simply do tableA_field = tableB.field; in the Control for AddLine under clicked(); However the fields in the new line is still empty.

What is the correct way of setting line fields to something upon adding them?

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi Dushatar,

You can make use of Datasource level initvalue method or table level initvalue method to default initial values to the form upon adding new line.

In your case you need to default header values to line, So write the code in line datasource initvalue method.

Thanks,

Girish S.

Was this reply helpful? Yes No
Dushatar 26 on at

Like (0)

Report

I think I got it to work.

I added it under the create method in the table which also calls initValue().

Does that seem reasonable? It seem to do what I wanted it to (values are now set when I create new lines).

Thank you =)

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Yeah you can make use of create method also.

Difference is when using init value method the new values are not automatically saved to the database when you leave the form.

To specify values that you want to save when you leave the form, Create method will be used.

Thanks,

Girish S

Was this reply helpful? Yes No
Dushatar 26 on at

Like (1)

Report

So if I understand you correct.

If I use initValue method it will only be saved to db when I press "save"?

If I use create method it will be saved to db as soon as the line is created?

Was this reply helpful? Yes No
Verified answer

GirishS 27,827 Moderator on at

Like (0)

Report

For example if your table has mandatory fields - Now you use create method to initialize value other than mandatory fields. So now you leave the form without giving value for mandatory fields, A new record will be created in the table without mandatory fields - This will create a orphan records in the table which should be avoided.

So my suggestion will be using the initvalue method to initialize the values instead of create method.

Thanks,

Girish S.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Set a line field to a header field when I "Add line".

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Set a line field to a header field when I "Add line".

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates