Forum Discussion

AnthonyCharrieu's avatar
AnthonyCharrieu
Qrew Member
2 years ago

Formula Rich Text -> test conditioned by Related link

Hello, I would like to create an app with 2 main functions: 1. Request Price 2. Answer to price request. You will see my app structure on picture "Capture.PNG". You will see the interface of ...
Formulas and functions
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

No problem

Make s summary field on the relationship between Price Requests and Sourcing Answers. It should be the 2nd radio button called Any Sourcing answers. This will be a checkbox field type which will be checked if there are any sourcing answers for the  price request.   


Then bases your formula on if that field is true. 



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
AnthonyCharrieu's avatar
AnthonyCharrieu
Qrew Member
2 years ago
Hello Mark,
thank you for your help.
however I did not manage to implement what I am looking for.
would you mind to detail a bit more how to put in place what you suggested.
sorry, I am starting to use quick base so I have a lot to discover and learn :)

------------------------------
Anthony Charrieu
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    Ok no problem. 

    Gi to the Relationship where One Pricing Request has Many Sourcing Answers.


    On the left side  of the relationship  will be a button to create a summary field. 

    Create a summary field using the 2nd audio button to detect if there are Any Sourcing Answers  

    Use that checkbox field in you formula.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------

    • AnthonyCharrieu's avatar
      AnthonyCharrieu
      Qrew Member
      2 years ago
      Ok thanks, I managed to create the summary field with the checkbox, I will be able to progress now :)

      ------------------------------
      Anthony Charrieu
      ------------------------------