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 | |
17 |