Suggested value depending on previous data

[Michel_van_Ruij]

How to get only the previous data in an enum list.

This formula in suggested values does not do it:

sort(SELECT(remarks[your name], and(([company] = [_THISROW].[company]),[proces]=[_THISROW].[proces])))

[Kirk_Masden]

Perhaps you could put your expression inside of an INDEX() expression to get the value before the latest one:

help.appsheet.com

INDEX()

One specific list item

[Steve]

What do you mean by “previous data”?

Also:

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), "My Table", "_ROWNUMBER", "Wanted Column" ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()

[Michel_van_Ruij]

The tabel “remarks” has the column [your name]. That column has lines with names ( previous data)

When entering new data in a form for a table called “remarks” I would like to see the previous entered names from remarks[your name] in alphabetical order drop down, but only if these names are from the same company and same proces: [_thisrow],[company] and [_thisrow].[proces].
Also adding new names must be available in the form.
Hope it explanes it clearly now.

[Steve]

The link I posted in my last response should help you.

[Michel_van_Ruij]

This formula is only allowed in a type " list" column.
My column if of type enum.
My form must produce a dropdown list of all names from same company and same proces.
This does not.