Need to update blank field in a table

guganvarman_21 · 2020-01-20

If the field is empty for today then I need to find the same field with yesterday date and increment the yesterday value and update the empty fileds today.

RockWithNAV · 2020-01-23

Seems like something you wan to be Auto Incremented??
You can handle this via code but see if Auto-increment Property works you.

kriki · 2020-01-22

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

RockWithNAV · 2020-01-23

Seems like something you wan to be Auto Incremented??
You can handle this via code but see if Auto-increment Property works you.

guganvarman_21 · 2020-01-23

Can you please give me a code for incrementing yesterday value..@RockWithNAV

RockWithNAV · 2020-01-23

@guganvarman_21 - Its a property in the TABLE for Integer Data Types

Check this out

https://docs.microsoft.com/en-us/dynamics-nav/autoincrement-property

guganvarman_21 · 2020-01-23

In my table let's say for ex. i have 23 records in the table where date field = today.In that 23 lines I'm going to update only one column B.The way i update is i see first i see what is the value for column B yesterday and i increment it and update the same incremented value in all of my today's records.Can you please share some coding techniques to achieve this.

Need to update blank field in a table

Best Answer

Answers

Categories