Is there a way to show in a dropdown multiple fields from a source table to make selections easier | populate another field based on the value in a different field
Two questions, probably dumb but I am still new to CASPIO
I am using List String and List Number data types in tables and populating the options from the contents of other tables. This works nicely.
What I would like to do is the following with an example.
The Employee table field DeptCode is a ListNumber sourced from table Dept. The dropdown on the Employee Creation form shows the list of possible departments which is great, but I would like the dropdown to show the department number (as it does) but also show the department name value for that record in the Dept table. This will make it easier for creators to pick the correct department.
I also have a field in Employee DeptName which is a ListString type also sourced from table Dept. I would like to know how to automatically load the proper department name based on the department number. I need to store them as separate items for reporting but would like to automate the load of department name based on its department number.
As a tertiary question, in this scenario, a user can select more than one department number and I would like to make this selection forced to be a single choice. I am sure that I have missed a setting in this regard.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
RossChevalier
Hello,
Two questions, probably dumb but I am still new to CASPIO
I am using List String and List Number data types in tables and populating the options from the contents of other tables. This works nicely.
What I would like to do is the following with an example.
The Employee table field DeptCode is a ListNumber sourced from table Dept. The dropdown on the Employee Creation form shows the list of possible departments which is great, but I would like the dropdown to show the department number (as it does) but also show the department name value for that record in the Dept table. This will make it easier for creators to pick the correct department.
I also have a field in Employee DeptName which is a ListString type also sourced from table Dept. I would like to know how to automatically load the proper department name based on the department number. I need to store them as separate items for reporting but would like to automate the load of department name based on its department number.
As a tertiary question, in this scenario, a user can select more than one department number and I would like to make this selection forced to be a single choice. I am sure that I have missed a setting in this regard.
Thanks in advance.
Ross
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.