Discussions

 View Only
Expand all | Collapse all

Separating a Form in Two with Unequal Sized Fields

  • 1.  Separating a Form in Two with Unequal Sized Fields

    Posted 01-29-2019 21:22
    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.


  • 2.  RE: Separating a Form in Two with Unequal Sized Fields

    Posted 01-29-2019 23:04
    Can you post a screen shot?


  • 3.  RE: Separating a Form in Two with Unequal Sized Fields

    Posted 01-29-2019 23:24



  • 4.  RE: Separating a Form in Two with Unequal Sized Fields

    Posted 01-29-2019 23:27
    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.


  • 5.  RE: Separating a Form in Two with Unequal Sized Fields

    Posted 01-29-2019 23:33
    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. _


  • 6.  RE: Separating a Form in Two with Unequal Sized Fields

    Posted 01-30-2019 20:43
    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. 




  • 7.  RE: Separating a Form in Two with Unequal Sized Fields

    Posted 01-30-2019 20:47
    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. 


  • 8.  RE: Separating a Form in Two with Unequal Sized Fields

    Posted 01-31-2019 16:12
    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?


  • 9.  RE: Separating a Form in Two with Unequal Sized Fields

    Posted 01-31-2019 16:13
    Sorry I meant the we have to input and save data in the form on the right in your example above.


  • 10.  RE: Separating a Form in Two with Unequal Sized Fields

    Posted 01-31-2019 16:49
    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"">https://whatever2.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. 



  • 11.  RE: Separating a Form in Two with Unequal Sized Fields

    Posted 02-01-2019 19:53
    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.


  • 12.  RE: Separating a Form in Two with Unequal Sized Fields

    Posted 02-01-2019 20:31
    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.