Forum Discussion

AndrewFry's avatar
AndrewFry
Qrew Assistant Captain
6 years ago

New record pop-out window - Issues

I have three tables: Work Orders, Subdivisions, Locations.

1 Subdivision to Many Locations
1 Subdivision to Many Work Orders

I am having some issues with windows popping out but not recording the input data.

When I add a new subdivision using the form within the subdivision table, it gives me an option from within the subdivision form to add a new location via an "Add Location" button.

I click it and it asks to save the subdivision, I click yes, then it takes me to the Locations table form, where the subdivision is already related to the new location I am creating. It does not pop out the locations table form to a new window. It simply takes me to the locations table form. Once I input the location and save, it takes me back to my subdivision table form so I can finish it off and save it. This works as intended.

The issue comes when I go to create a new work order with a new sub division and a new location all at the same time.

I go to add a new Work Order. From within the new work order form I can add a new subdivision. However it isn't via a button but a drop down menu (maybe this is the issue???). I click the Add new subdivision in the drop down menu and a new window pops up where I can input the new subdivision. From within that "Add new subdivision" pop-up window, I can then click add new location from the drop down menu. It asks to save the subdivision, closes the window, and no new window for the new location is opened.

No error message, no new blank record ... simply nothing happens.

The subdivision is saved but I am not able to input a new location.

I think the issue stems from the pop-up window not being able to open an additional popup window for the locations.

Ideally, I would like to avoid the popup windows. I would much rather that clicking the "New Subdivision" in the work order drop down, take me to the subdivision table form, then from there clicking the new location takes me to the Locations table form. Once saved, it then takes me back to the subdivision. Then once saved back to the work order for me to continue.

Any thoughts as to why the above is happening? How to fix it? How to make the forms go to the tables/forms rather than open a pop-up window?

Thanks a ton for your help!!
  • I doubt there is a native way to change that behavior if you want to continue to allow users to create new subdivisions and new locations "on the fly" like that.  

    You alternative (which may be a worse alternative) is to change those roles to suppress the Add button under the User Interface settings for the Role.  I believe that will prevent the Add Subdivision or Add Location option from appearing at the bottom of the list at all.  

    • AndrewFry's avatar
      AndrewFry
      Qrew Assistant Captain
      Thanks Mark for the info.

      Any idea why when I add a new subdivision, from within the work order, then add a new location from within the new subdivision, it closes the new subdivision window but doesn't open a window to add the new location?
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      I was able to duplicate the issue, but I think it's because Quick base is still trying to deal with saving the Work Order and then you are sort of nesting in a save of a Subdivision, and then trying to save a Child on the Subdivision (ie the location)  before you have actually saved the workorder and QuickBase can't handle that situation.

      One suggestkion though.

      On any parent table always check the box in Advanced settings for

      Save parent record automatically when a child record is created 

      _From the user perspective, the answer will always be "yes" (ie yes you dummy App Builder of course I want to save the Parent so I can continue to add the child. Why else do you think I took the time to do that data entry to create a Parent, if not to save it?").  That box really should default to checked, imho, but for legacy reasons I think,  it does not.  
    • AndrewFry's avatar
      AndrewFry
      Qrew Assistant Captain
      That is a great point Mark. Thanks for the pointer.
  • There is no equivalent, at this time, to cell colorization or conditional formatting like in Excel. The closest that you can come is to make a formula text field, but then you will lose you totals as this will be a text field, not a number.  

    This link shows how to change the background color.

    https://help.quickbase.com/user-assistance/color_field.html

    There are simpler formuals if you want to change just the font color.

    Like



    if([my field] > 100, "<font color=red>"     & ToText([my field]),
                                  "<font color=green>" & ToText([my field]))