Skip to main content
Question

All Fields not appearing in Pipelines "Select Fields to Specify Values"

  • October 10, 2024
  • 0 replies
  • 172 views

Forum|alt.badge.img+7

I'm trying to create a pipeline that will create a new record in my decisions table if a new record in requests is created. 

Was able to set up the On New Event section, but when I then try to set up the Create Record section, the fields I need to specify values (Approver Name, Approver Role) are not options.  

What do I do so I can make those fields options/selectable? 

Kim

Forum|alt.badge.img+15
  • Quickbase Alumni
  • October 10, 2024

Are those already mandatory fields in the [Decisions] table?   If so they are on the Pipeline Step already and cannot be selected again.


Forum|alt.badge.img+7
  • Author
  • Quickbase Alumni
  • October 10, 2024

Huh.  Well then how can I automate creating new decision records for each approver role so I can then notify who still needs to approve a request?


Forum|alt.badge.img+15
  • Quickbase Alumni
  • October 10, 2024

If they are Mandatory, they will be there already. Here is an example

Notice that Select Fields is blank.

However Name is underneath it waiting to be filled.    Because Name is mandatory, you do not select it.


Forum|alt.badge.img+15
  • Quickbase Alumni
  • October 10, 2024

Please send screen shot of the fields from the table.

 


Forum|alt.badge.img+7
  • Author
  • Quickbase Alumni
  • October 10, 2024

Here's screenshot of Decisions Process table fields.


Forum|alt.badge.img+15
  • Quickbase Alumni
  • October 10, 2024

I can see it now.   The fields you want to fill are Look Up fields from the Approvers table.    You can not set those.    You need to set the Related Approver.   Then all of those will be populated.


Forum|alt.badge.img+7
  • Author
  • Quickbase Alumni
  • October 11, 2024

Thanks again Don for all your help!  :)