Forum Discussion
Solved
Autofill columns in List
Hi how can I make that when I create a new Item in a List, the OrderingNr. field is automatically filled with the number that comes after the last entry? Many thanks in advance for your help
smajic175
Ok, let me see if I get that right.You created a column "Bestell-Nr." to hold the combined String "BN210-1". Correct?
Do I get it right that you renamed the "ID" column into "Bestellnummer"?
I setup a list as I suppose you did. Here is what I noticed:
I currently entered item 3. You see the formula doesn't work. Even after reloading the list it won't change.
Now I go back into the list settings, open the settings for the column and do nothign else but save it again:
And then this happens:
Don't ask me why. It is really weird.
Tried it again and it won't work again. So I changed the formular, saved the column;changed the formula again and saved it again. And it would work again. That is all but satisfying.
Have you thought of replacing the standard edit form with a PowerApp (Integrate | PowerApps | Integrate Forms). You could add a field there which does the calculation for you with even more options of formating the string. Just a thought.
Hi I tried and put in following ="2100"+ID
and it works partially, since when I add a new Item to the List it shows following, see the last Item added, it shows then 2100 instead of 2342
Please read my instructions again.
It's not
"2001"+ID (which probably converts the string to a number and then adds the ID) but
"2001" & [ID] - the "&" is a string operator, whilst the "+" is a math operator. Plus the columns content is return but the columns name in square brackets [ and ].
Please try again
It's not
"2001"+ID (which probably converts the string to a number and then adds the ID) but
"2001" & [ID] - the "&" is a string operator, whilst the "+" is a math operator. Plus the columns content is return but the columns name in square brackets [ and ].
Please try again
smajic175
Ok, let me see if I get that right.You created a column "Bestell-Nr." to hold the combined String "BN210-1". Correct?
Do I get it right that you renamed the "ID" column into "Bestellnummer"?
I setup a list as I suppose you did. Here is what I noticed:
I currently entered item 3. You see the formula doesn't work. Even after reloading the list it won't change.
Now I go back into the list settings, open the settings for the column and do nothign else but save it again:
And then this happens:
Don't ask me why. It is really weird.
Tried it again and it won't work again. So I changed the formular, saved the column;changed the formula again and saved it again. And it would work again. That is all but satisfying.
Have you thought of replacing the standard edit form with a PowerApp (Integrate | PowerApps | Integrate Forms). You could add a field there which does the calculation for you with even more options of formating the string. Just a thought.- You realize that you are trying to create a column for type "single line of text", don't you? That'S not what I was talking about. I think you still try to create a column from the fancy UI view which doesn't work for "calculated" columns because they aren't offered as an option here.
Okay, let's try another approach:
From your list select "Add column" and then select "More...". You are now taken to the column creation. (See my screen shot above)
Give your column a name and select "Calculated" and add the formula to the "Formula" field.
Save the column (save button is at the very end of the screen; you might have to scroll. Hi now I did what you said,
and put in ="BN.210-"&[ID]
still shows this
the brackets [] get lost every time I save and close the settings
