I want to emulate Sample Custom App Launcher but instead of launching/opening other apps, I want to display the forms the logged on user can access. My users are all assigned certain ROLEs (PI_NO) which give them specific tasks they can do based on that role. Such as, data entry, review and approve requests of those under them and probably more.
In the Sample Custom App Launcher, the Launcher table has the URL to each app listed. I would like to call a LINKTOVIEW(โFormBasedOnUsertableโ)
Simply putting a specific LINKTOVIEW(โS_ASIA_Curateโ) did not work. There is not a data type for Form or Expression that I could find.
I tried multiple other ways and nothing worked. Any ideas of how to have a menu type opening form, with or without images? Simply as a way to navigate the app based on data in the User table?
Lucinda
Solved! Go to Solution.
Open that main viewโs definition and choose App link with the option โRow selectedโ.
Hi lucinda, please use #control=S_ASIA_Curate in your spreadsheet and it should work with the App column.
Thank you Aleksi.
Open that main viewโs definition and choose App link with the option โRow selectedโ.
If I may trouble you again.
Previously I was using a form to have the user select their role (PI_NO) and then used an action to open the appropriate data entry form.
The action:
LINKTOFORM(
SWITCH( [PI_NO],
โ2โ , โJFAPI_Data_Entryโ,
โ3โ , โJFCPI_Data_Entryโ,
โ4โ , โJFPI_Data_Entryโ,
โ5โ , โJFDPI_Data_Entryโ,
โ6โ , โJFTPI_Data_Entryโ,
โ7โ , โJFTPI_Data_Entryโ,
โEnter Requestโ ),
โPI_NOโ,[PI_NO])
That worked perfectly, but now I have a USERS table and want to get the PI_NO from it based on the USEREMAIL() of the logged in user.
The USERS table has USER_EMAIL and PI_NO as fields. How do I do the reference in the above expression to connect the logged in user and get the PI_NO?
Thanks again. I have a big learning curve, been out of doing any app/db design since my Microsoft Access days in the 80โs.
Lucinda
Instead of writing like [PI_NO], you could use LOOKUP(USEREMAIL(),โUsersโ,โEmailโ,โPI_NOโ)
Thanks Alexsi. Iโm not sure where to place the lookup expression.
This expression ran without errors but didnโt give me the results based on the userโs PI_NO.
LINKTOFORM(
SWITCH([PI_NO],
โ2โ , โJFAPI_Data_Entryโ,
โ3โ , โJFCPI_Data_Entryโ,
โ4โ , โJFPI_Data_Entryโ,
โ5โ , โJFDPI_Data_Entryโ,
โ6โ , โJFTPI_Data_Entryโ,
โ7โ , โJFTPI_Data_Entryโ,
โEnter Requestโ ),
[PI_NO],(LOOKUP(USEREMAIL(),โUsersโ,โUser_Emailโ,โPI_NOโ)))
Obviously Im not understanding. Or maybe Iโm just calling the action from the wrong place. I was calling it from a dummy form based on the user table so that seemed to be capturing the record I was on instead of the logged in user.
LINKTOFORM((LOOKUP(USEREMAIL(),โUsersโ,โUser_Emailโ,โPI_NOโ)
SWITCH([PI_NO],
โ2โ , โJFAPI_Data_Entryโ,
โ3โ , โJFCPI_Data_Entryโ,
โ4โ , โJFPI_Data_Entryโ,
โ5โ , โJFDPI_Data_Entryโ,
โ6โ , โJFTPI_Data_Entryโ,
โ7โ , โJFTPI_Data_Entryโ,
โEnter Requestโ ),
โPI_NOโ,[PI_NO]))
LINKTOFORM(
SWITCH((LOOKUP(USEREMAIL(),โUsersโ,โUser_Emailโ,โPI_NOโ),
โ2โ , โJFAPI_Data_Entryโ,
โ3โ , โJFCPI_Data_Entryโ,
โ4โ , โJFPI_Data_Entryโ,
โ5โ , โJFDPI_Data_Entryโ,
โ6โ , โJFTPI_Data_Entryโ,
โ7โ , โJFTPI_Data_Entryโ,
โEnter Requestโ ),
โPI_NOโ,[PI_NO]))
Hi Aleksi,
I am also facing a similar issue.
But, somehow, I couldn't find the option you have mentioned. Could you pls share a screenshot?
I have a Home view (Details view type) with Image, Title, Description & Link (Name of the View) & a virtual column > "#view=&[Link] with App as Data field to open 2 Forms.
Always ending up with a view similar to what Lucinda had.
I am having tough time to just show the icon with Title & Description as a clickable link to open respective views. Any help would be much appreciated.
Thanks.
Thank you so much.
Hi @Lucinda_Mason
The Oil rig Inspection forms sample apps have lots of forms. You may find some ideas in those.
Thanks Lynn. Iโll definitely have to study those. So much to learn. Thanks for pointing me.
Tryโฆ
LINKTOFORM(
SWITCH(LOOKUP(USEREMAIL(),โUsersโ,โUser_Emailโ,โPI_NOโ),
โ2โ , โJFAPI_Data_Entryโ,
โ3โ , โJFCPI_Data_Entryโ,
โ4โ , โJFPI_Data_Entryโ,
โ5โ , โJFDPI_Data_Entryโ,
โ6โ , โJFTPI_Data_Entryโ,
โ7โ , โJFTPI_Data_Entryโ,
โEnter Requestโ ),
โPI_NOโ,LOOKUP(USEREMAIL(),โUsersโ,โUser_Emailโ,โPI_NOโ))
THANK you so much Aleksi. That worked. I so appreciate your help.
Youโre welcome
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |