Forum Discussion
DavidBrogdon
7 years agoQrew Assistant Captain
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.
- DavidBrogdon7 years agoQrew Assistant CaptainThere 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. - BarryGulino7 years agoQrew CadetThis 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?
- BarryGulino7 years agoQrew CadetSorry I meant the we have to input and save data in the form on the right in your example above.
- DavidBrogdon7 years agoQrew Assistant Captaincreate 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. - BarryGulino7 years agoQrew CadetDavid 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.
- DavidBrogdon7 years agoQrew Assistant CaptainNot 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.