Forum Discussion

TonySugent's avatar
TonySugent
Qrew Member
5 years ago

Formula help

I just joined this company that uses QuickBase as their main ticketing program so I'm still a little new to this. I'm currently tasked with creating a automation for the Onboarding and offboarding pro...
Formulas and functions
TonySugent's avatar
TonySugent
Qrew Member
5 years ago
Yep! I'm the DevOps Engineer here. The API call just shows as a URL though haha. 

Nope, it would be a 1 to 1. Although that is a good idea to have an overarching percentage as well.

Basically the Onboarding ticket is just a list of open task tickets related to that specific employee and I would like to just have the Complete % (a field that is manually filled in in the task ticket) displayed next to the tasks entry in the Onboarding ticket. I can post some screenshots here shortly if that was a poor explanation.



------------------------------
Tony Sugent
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
yes, in this case a screen shot would help and also I'm confused if there is a Quick Base relationship between the Onboarding tickets table and the tasks table.  From you question it sounds like the relationship is that One Onboarding Ticket has many Tasks.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • TonySugent's avatar
    TonySugent
    Qrew Member
    5 years ago
    Mark,

    The attached screenshots demonstrate where were are trying to get the percent complete from (TT#6998) and the onboarding ticket that we are trying to get the percent to. So far all the information in the onboarding ticket is put in their through an automation with the exception of the complete field. I hope this helps.




    ------------------------------
    Tony Sugent
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      Still very confused. Do you have a relationship between the on boarding tickets table and the task table and if so which one of them is the One and which is the Many in the relationship.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
    • JordanMcAliste1's avatar
      JordanMcAliste1
      Qrew Member
      5 years ago
      I would suggest using a summary field (combined text or something else in that category that fits your needs) or use an automation in the same way you do with the other information. I don't think you are going to be able to get data in the form of an API URL to show up in a field. If you wanted a non native way to shoot that info up to the parent you might need a code page or some AJAX call to initially grab that information.

      ------------------------------
      Jordan McAlister
      ------------------------------