Please tell me the method and steps to display in the form view of Plane only in the format of [StaffID]Staff name, and in other views, display only the Staff name
ใDBใ
โ Staff
StaffID
Staff name
โ Plan
PlanID
Plan name
Planner๏ผREF๏ผStaff๏ผ
If I understood your request and details, select the "Staff name" column in the Staff table as a label column and you should be fine.
Thanks for the reply.
Sorry for not communicating the question correctly.
I am aware that Appsheet does not allow to set LABEL for each view, but I would like to change what is displayed for each view.
ใDBใ
โ Staff
StaffID
StaffName
VC_[StaffID]StaffNameใใโปFORMULA๏ผ"๏ผป"&&[StaffID]&"๏ผฝ"&[StaffName]
โ Plan
PlanID
Plan name
Planner
ใDisplay exampleใ
โ Plan Detail๏ผInlineview
John Smith
Sarah Johnson
Michael Williams
Emily Brown
David Jones
โ Plan Form view
[10]John Smith
[11]Sarah Johnson
[12]Michael Williams
[13]Emily Brown
[14]David Jones
If you need to show the [10]JohnSmith wth the dropdown, you need to use that as a label column. But you can hide that column from the detail or inline view as you can select which columns to show with views definitions.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |