Forum Discussion

AnthonyCharrieu

Qrew Member

3 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

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

3 years ago

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
Qrew Member
3 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
  Qrew Legend
  3 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
    Qrew Member
    3 years ago
    Ok thanks, I managed to create the summary field with the checkbox, I will be able to progress now :)
    
    ------------------------------
    Anthony Charrieu
    ------------------------------