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

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
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
Photo of Jan-Willem

Jan-Willem

  • 490 Points 250 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
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
Photo of Jan-Willem

Jan-Willem

  • 490 Points 250 badge 2x thumb
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?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,372 Points 20k badge 2x thumb
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.
(Edited)
Photo of Jan-Willem

Jan-Willem

  • 490 Points 250 badge 2x thumb
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.
 
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
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.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,372 Points 20k badge 2x thumb
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++
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
:). 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.