hide the data for another users
Hi, I want to display the highlighted "documents" only when the status is approved for specific user and it should not show the another documents. (like me requesting to access the documnet fiel...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou cannot show/hide columns on a report, but in fact there is an elegant solution.
This syntax as a formula Rich Text field will create a link to the file and display the file name as the link to click on.
var text Words = ToText([documents]);
var text URL =URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0";
"<a href=" & $URL & ">" & $Words & "</a>"
// change the 99 to the field ID of [documents]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
This syntax as a formula Rich Text field will create a link to the file and display the file name as the link to click on.
var text Words = ToText([documents]);
var text URL =URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0";
"<a href=" & $URL & ">" & $Words & "</a>"
// change the 99 to the field ID of [documents]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MarkShnier__YouQrew Legend
Qrew Legendsorry, I meant to add that now you can make a formula to display that field of the user is approved to view.
so it woul;d be like
var text Words = ToText([documents]);
var text URL =URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0";
IF([user is allowed to view] = true,
"<a href=" & $URL & ">" & $Words & "</a>")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
so it woul;d be like
var text Words = ToText([documents]);
var text URL =URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0";
IF([user is allowed to view] = true,
"<a href=" & $URL & ">" & $Words & "</a>")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thanks for your reply mark. but i have one query how can we mange the users as multiple users can raised the request for access the same document ?
------Original Message------
sorry, I meant to add that now you can make a formula to display that field of the user is approved to view.
so it woul;d be like
var text Words = ToText([documents]);
var text URL =URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0";
IF([user is allowed to view] = true,
"<a href=" & $URL & ">" & $Words & "</a>")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- MarkShnier__YouAre you saying that the permission is per use for multiple users and also per document for multiple documents?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- permission is for multiple users per document and multiple document per user means1. multiple users can have the permission on one document.2. one user can have permission on multiple documentshow can i handle on below formula:If([Status]="Approve",
var text Words = ToText([documents]);
var text URL =URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e14/v0";
"<a href=" & $URL & ">" & $Words & "</a>","")
------Original Message------
Are you saying that the permission is per use for multiple users and also per document for multiple documents?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
