Dear friends, There is form view and i am ad...

ux
(Etwo Cargo) #1

Dear friends,

There is form view and i am adding data via that form [normal steps]. A name, B surname, C contact…and then save. Is it possible to have details if i write same name in column A? I know that not possible to save same name. Just i want to edit it.

name

surname

contact ABCD

EFG

123456 KLMN

IOP

987654

when i write ABCD system need to show me details of ABCD and then i will change something and then save

(Levent KULAÇOĞLU) #2

@Etwo_Cargo

You can write below expressions in Suggested_Values property of ColumnB and Column C

SELECT(Tablename[ColumnB],[ColumnA]=[_THISROW].[ColumnA])

SELECT(Tablename[ColumnC],AND([ColumnA]=[_THISROW].[ColumnA],[ColumnB]=[_THISROW].[ColumnB]))

And in Initial Value you can use ANY() expression to select the first valid value from the list

(Etwo Cargo) #3

@Levent_KULACOGLU Dear Levent, Shall i write both of them in same [suggested_value] section?

(Levent KULAÇOĞLU) #4

@Etwo_Cargo

Writing both of the expressions to same suggested_value property (that means you concatenate 2 lists) gives you nothing. The first SELECT is for ColumnB’s suggested value and the second one is for ColumnC’s suggested value.

The first SELECT will filter ColumnB values as per your choice in ColumnA and the second one will filter ColumnC values as per your choices in ColumnA and ColumnB

(Etwo Cargo) #5

@Levent_KULACOGLU Wow supper. What about if i have 40 column? Is it means that formula will be much big? :slight_smile:

(Levent KULAÇOĞLU) #6

@Etwo_Cargo

Es besteht keine Notwendigkeit, die Grenzen zu erzwingen😊 Translate

(Etwo Cargo) #7

@Levent_KULACOGLU

Haklısın. Kusura bakma. Translate