Report Output Not Showing Quantities After Survey Submission

Title:
Report Output Not Showing Quantities After Survey Submission

Hi everyone,
I am a complete novice to the APP world and have been tasked with
building a site survey app to be used by technicians so standardized information can be captured and sent in the warehouse for parts pulling. I am having trouble with my report output after a survey is completed and submitted. The results are sent as csv format. I only see the following report lines as output, but no quantity values are displayed—just the headings:

  • Total TCUs
  • Inmate Teguar Units
  • Tablet Units
  • Total Phones
  • Total Cable Runs
  • Total Rack
  • Wall Standard Rack Qty
  • Wall Extended Rack Qty
  • Floor Short Rack Qty
  • Floor Extended Rack Qty
  • Total WAPs
  • Teguar Visitor Units
  • Notes

Each of these lines should display a quantity or value next to it. The values are being recorded in my tables (for example, in the Survey Summary table and others), but I’m not sure how to properly display these quantities in the report output or on the final screen.

Is there anyone that can take a look at my layout and guide me in the right direction? This final step has become very frustrating.

Questions:

  • What is the best way in Glide to display the values from my table(s) next to each report line after survey submission?
  • Should I use a certain layout or component?
  • Any tips for ensuring the correct data is mapped to the correct report line?

Can you add some screen shots please? Both of your layout and data.

I have tried to upload all the relevant tables and all the screen layouts. I am sure I’ve gots lots of columns that are surplus but to my defense that’s what ChatGPT tells me.

I like my layout. It works for me but if there are better, more streamline methods then I am in. The main thing I am trying to achieve is that when a technician does a survey that the output is standardized. That when a piece of hardware is selected it is linked to the new (recommended) part and when the survey is complete and submitted that the email link generates the correct data with quantities.

Can you tell me more about the above?
How are you generating the CSV?
Are you using the Generate CSV action?
Can you show me the workflow involved, and which table it is attached to?

I know I’m close to getting the correct output but when I look at the survey summary table I see query in columns where number should be. There is some sort of misconfig somewhere but I can’t find it.