Forum Discussion

preetiverma1's avatar
preetiverma1
Qrew Member
5 years ago

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 field after getting approved. i will able to see only that document not others.) 

thanks

------------------------------
preeti verma
------------------------------
APIs and custom code
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    You 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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      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
      ------------------------------
      • preetiverma1's avatar
        preetiverma1
        Qrew Member
        5 years ago
        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
        ------------------------------