Forum Discussion

MarkStenberg2's avatar
MarkStenberg2
Qrew Trainee
11 years ago

URL formula button to open pop-up box to collect data

I'd like to take a URL formula button which creates a new record and bring up a small window to collect a few fields of data which would then be written to the new record. Does anyone have any code ...
Formulas and functions
Tables and fields
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
11 years ago
M>no problem ... URLRoot()

I think the OP wanted a modal PopUp dialog not the opening of a new page. This example from June 19, 2011 demonstrated how you can create modal dialogs in the style of QuickBase's Popup (click on Test1 and Test2 buttons to demo):

MyPopDivs Not YourPopDivs
https://haversineconsulting.quickbase.com/db/bfuw7wt8a

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=7


Note that the code in the pastie and links points to the www subdomain not haversineconsulting as it was created before the great migration to UX2.
  • MarkSpringthorp's avatar
    MarkSpringthorp
    Qrew Trainee
    8 years ago
    Dan, is this method still appropriate to use or is there a better way?  It looks exactly like what I need but when I look at the pastie, I'm unsure of what code to put where in QB. Appreciate your help, Mark
  • MarkSpringthorp's avatar
    MarkSpringthorp
    Qrew Trainee
    8 years ago

    Thanks Dan, much appreciated!


  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    8 years ago
    Do you think this will work if on a click this model shows up and on it have all the required fields showing up to create a new child record and when I hit save, a new record is added to parent?
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    Yes if you modify the script to meet your needs.
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    8 years ago
    What is "var csvData = "";" and the function followed by it doing? 
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    It is building up a string of csv data with newlines (ie \n) separating each line of data so that it can be posted to a table using API_ImportFromCSV.