Hi, I am new to the appsheet. I first thought it could be helpful to our company even I had no coding knowledge or programming background.
Background info of the app I am working on:
Basic employee info. list,
I have a google sheets with main tab “employee list” and some other tabs with information of either personal info. or corporate info. of the employee, which I want to use as reference.
In one tab, I have all job titles, with it’s corresponding dept and level.
I’ve made a dependent drop down for the job titles I can choose from with the dept info. chosen above.
And I want to get the “level” info. corresponding to the job title chosen.
As both dept and job title was set to type “text”. I can not use dereference for the "“level”.
So then I tried several ways, I made “level” as ref and linked to the “job title” sheet which has all job titles, related level and dept. I used in valid if, lookup([Employee Level], “Job Title”, “Job Title”, “Employee Level”). But it’s not working. Also tried in app forumla, not working.
And before I figured that out. When I tried to make it as pure text, I found the level itself disappered or missing from the form view, whether I double confirmed several time the tick of “show” or in the form view, column order, manually added all the columns. Neither was working. And only way is to go back to the sheet and input it there, which then showed up in the app view.
So I have these 2 problems,
- the missing of “level” column in the form view
- how to get the “level” info. related to the job title (chosen on the dependent drop down list).
Not sure if I described the situation clear enough, really need some help here.
Thank you so much in advance!!!