Discussions

 View Only
  • 1.  Values treshold / lookup table in table on rich-text page

    Posted 02-06-2018 14:32
    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


  • 2.  RE: Values treshold / lookup table in table on rich-text page

    Posted 02-06-2018 15:03
    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


  • 3.  RE: Values treshold / lookup table in table on rich-text page

    Posted 02-06-2018 17:50
    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?


  • 4.  RE: Values treshold / lookup table in table on rich-text page

    Posted 02-06-2018 17:59
    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.


  • 5.  RE: Values treshold / lookup table in table on rich-text page

    Posted 02-06-2018 21:49
    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.
     


  • 6.  RE: Values treshold / lookup table in table on rich-text page

    Posted 02-06-2018 21:58
    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.


  • 7.  RE: Values treshold / lookup table in table on rich-text page

    Posted 02-06-2018 22:39
    I have to admit that this is pretty simple. Were you on the slopes or at the ski lodge when you came up with this ingenious solution?

    native++


  • 8.  RE: Values treshold / lookup table in table on rich-text page

    Posted 02-07-2018 05:45
    :). In the room. I�m skiing with a group and they won�t wait for me

    Another thought not tested is that the report might take up a bit less space as a website element with the report url suffixed with &ifv=1

    But I did not get time to test.