Forum Discussion

brian_s's avatar
brian_s
Qrew Trainee
19 days ago

Showing dynamic fields on a report?

My app has a number of dynamic fields that show based on a location field.

Everything is working properly. Except, when I just click the eyeball to view the record, I only see the fields that are mandatory on the default report. 

I know I can open it to see it all, but is there a way to get these additional fields to show? Ideally only fields that are either populated OR the dynamic fields from the actual form that show based on that location.  I do see the location as being set on the default report. 

Can this be done with a report at all? If not the default can I create a new report that will allow me to show these fields and link to it from another report? I have a report on the front page for all new entries and another for new entries that week. 

  • brian_s's avatar
    brian_s
    Qrew Trainee

    Sorry... so the "View" option for a record will only show fields that are not controlled by dynamic rules that show on the form when creating a record?

    So does this mean fields based on reports can not be shown at all on a report? There is no way to force them to show even if there is no data?

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend

      I think we are still struggling to communicate with each other so let's keep trying.  

      When you click to view a record with the eyeball on a report, it will display the single record on a form.

      I don't know whether you are using legacy forms or new style forms, but either way you were in control of which fields show on the form and whether they are controlled dynamically according to form rules.

      i'm not sure if this was your question but once you have multiple forms, which I really don't recommend, but if you do have multiple forms, then it is possible to go to the form usage settings and associate particular forms with particular reports.

       

      but in my experience, you are far better off having a single form and using form rules to control which fields or ideally which sections or Tabs show.

      Are we on the same wavelength yet? Am I understanding your question?

      • brian_s's avatar
        brian_s
        Qrew Trainee

        Apologies for the confusion, one of my colleagues just corrected me on part of what I was miscommunicating in terms of forms vs. reports. 

        We are using the legacy forms and the problem I am having is on the form, not a report.  I attached a file with screenshots explaining what I was doing and what I am missing. 

        My issue appears to be with the form for VIEWING. 

         

  • I'm a little confused by the text in your question but I think your question is really in the headline of your post. I think you were asking whether a report can dynamically change columns based on whether or not Thursday in those columns.

     

    I'm a little confused by the text in your question but I think your question is really in the headline of your post. I think you were asking whether a report can dynamically change columns based on whether or not Thursday in those columns.

     

    The answer is no there is not a way to have a report dynamically change columns.