Separating a Form in Two with Unequal Sized Fields

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
We are working on a project that involves auditing web pages.  The community helped me solve the initial problem with a rich text field to frame in the webpage we are auditing.  The problem is we have to be able to view the entire page and answer auditing questions on that specific page.  We would like in our form to be able to see the page (rich text field) on the left and then the auditing fields on the right.  The problem is I can align the first field with the top of the rich text field, but the next field falls on the right but below the rich text field.  This requires scrolling down to answer the questions instead of looking to the left and answering directly to the right.  I think the ability to embed forms inside a form may work.  Can we have the rich text field on the left and another form with tabs on the right to navigate between the questions.  Not sure if there is a way to pull this off, any help would be appreciated.
Photo of bgstatdex

bgstatdex

  • 380 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Can you post a screen shot?
Photo of bgstatdex

bgstatdex

  • 380 Points 250 badge 2x thumb

Photo of bgstatdex

bgstatdex

  • 380 Points 250 badge 2x thumb
When setting up the form I can place as many fields as I want at the top line.  But when I want to put a new line of fields it goes directly to the bottom of the rich text field "Test URL".  I want four or five lines underneath each other on the right of the rich text field.
Photo of bgstatdex

bgstatdex

  • 380 Points 250 badge 2x thumb
I reduced the size of the rich text field to show how it looks.  The field will actually be twice that height so the other questions will be much lower and take longer to answer as you would have to scroll up and down.  Also another 15 questions exist.  I also noticed we could possible create a formula link that would open up to a popup that we could move around the page.  I just can't find any instructions on how to setup the advanced section to possibly keep it up front and not behind the window we are inputting information in. 
Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb
Just create a create an otherwise empty form and usetwo frames, one for the webiste you need, and the other for the form you need to use. 


Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb
There will need to be some various rules here of course. For example, you dont want them to be able to save the record from this host form. I suggest creating a required field that cant be filled in, therefore preventing the record from being saved. There are other methods I'm sure.

Another option is a special dashboard just for this function. 
(Edited)
Photo of bgstatdex

bgstatdex

  • 380 Points 250 badge 2x thumb
This sounds perfect, but how do I create a form with two frames?  Create the frames with a rich text formula field?  But I think that defeats the purpose because I have to actual input data in the form to the left in your example and be able to save that record.  I didn't think I could create a rich text field that you could interact with.  Or am I missing something?
Photo of bgstatdex

bgstatdex

  • 380 Points 250 badge 2x thumb
Sorry I meant the we have to input and save data in the form on the right in your example above.
Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb
create two formula text fields like these:

"<img data-url='" & [URL1] & "'" &
" src onerror='\n\n(async () => {\n  var url = this.dataset.url;\n  this.outerHTML = `<iframe src=${url} width=700px height=600px></iframe>`;\n})();\n\n'>"

"<img data-url='" & [URL2] & "'" &
" src onerror='\n\n(async () => {\n  var url = this.dataset.url;\n  this.outerHTML = `<iframe src=${url} width=700px height=600px></iframe>`;\n})();\n\n'>" 

Then, create two formula url fields like these:

"https://whatever1.com"
"https://myquickbaseform.com"

Next, create a blank form to hold the two frame fields. the first frame will be your source website. The second frame will be the original form that you need to enter data on. Just make sure that your users are saving on the embedded form and not on the container form. 

(Edited)
Photo of bgstatdex

bgstatdex

  • 380 Points 250 badge 2x thumb
David created the container form and the layout works great, but the problem is when I drill down to the form.  We work from different views/queues so when we click the record we are trying to edit, it doesn't link that record into the form.  Can that be fixed?  If not it's basically a split screen with two windows.
Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb
Not entirely sure the issue you are having, but if it is just linking a record ID into the child record, you can pass that value to the container form, then pass that field into your url formula.