Forum Discussion

Jan-WillemSpeck's avatar
Jan-WillemSpeck
Qrew Assistant Captain
7 years ago

Values treshold / lookup table in table on rich-text page

Hello all,

With all options I discovered so far  I would be disapointed if there is no way to present the values that are hold in a threshold table (record ID#1) on a rich-text page.

I have a table that contains various thresholds like ie something like 'maximum_number_of_days' and 'max_costs_hardware'.

In the documentation and instructions around the app on a rich-text page I would share these values with the users and to avoid mismatch and the need to change that page with every change in the table I like to show them directly from the source table (if possible) enbedded in the instructions.

Would that be possible?

Thanks

JWS

7 Replies

Sort By
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    Working with your existing Rich Text page it is possible to put some raw HTML into it that will include a <script> tag. Editing the Rich Text page is a little tricky as it is not designed primarily for the easy entry of of HTML or JavaScript. But it can be done and the easiest way of introducing the table of parameters ( 'maximum_number_of_days' and 'max_costs_hardware'.) is through using API_GenResultsTable.

    The result might look like this conceptually but it depends on your existing Rich Text page content"



    It is a bit tricky to edit a Rich Text page in this fashion and the instructions are a bit difficult to explain via the forum.

    Feel free to contact me off-world if you want to pursue a solution:

    https://getsatisfaction.com/people/dandiebolt
  • Jan-WillemSpeck's avatar
    Jan-WillemSpeck
    Qrew Assistant Captain
    7 years ago
    Mmmmm that's not quite the type of presentation I was looking for.
    I was hoping to create a table om the instruction page and show just the values with more human language instead of fieldnames.
    Would the code page option be more appropriate for this perhaps?
    • _anomDiebolt_'s avatar
      _anomDiebolt_
      Qrew Elite
      7 years ago
      It can be done with either a Rich Text page or a Code page and look anyway you want to spec it out. It is just more difficult on a Rich Text page as you have to edit HTML and there are several changes QuickBase makes to the page when it is saved that might change your code.

      I only suggested the simplest way to do it using a Rich Text page because it seemed like you put some effort into creating one already and just wanted to add the parameters.
    • Jan-WillemSpeck's avatar
      Jan-WillemSpeck
      Qrew Assistant Captain
      7 years ago
      For me ( to create a page) rich text looked easier to type text.
      If a code-page is easier I will go that path.

      In relation to the example you made I would only like to show '30' or '2000' on the page.
      IE:
      ".... any change request above USD <2000> must be approved within <30> days..."
      I was hoping there would be something like an URL code format available that would copy the value onto the rich/code page.
       
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      Jan,
      Why not just put the report of your threshold records on the Dashboard. It will only have 1 record in it. Then you can make a formula to present the thresholds in a user friendly sentence and you can use HTML to format it. Ie just display the formula field on the Dashboard report.