Answers.Body: <p>If you are using Drupal as your CMS then one option would be to set-up a webform that simultaneously opens a case and a grant (yes, webforms can do both at once). In that case the webform submission itself could serve as the link between the two, or you could make a more explicit link via custom fields.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-29T14:58:44.703Z
Answers.Text: Nice idea!  When you say "you could make a more explicit link via custom fields" would that be to record the Grant/Case ID or somehow build a link?
Answers.UserDisplayName: Sonicthoughts
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-29T15:05:42.360Z
Answers.Text: Storing the id in a custom field would require custom code, probably in a _post hook, unless you just do it manually each time. So if you're going to that trouble you might as well make it a link not just an id.
Answers.UserDisplayName: Coleman
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-29T14:48:34.177Z
Answers.LastActivityDate: 2015-07-29T14:48:34.177Z
Answers.UserDisplayName: Coleman
Answers.Body: <p>One option would be to create your own custom Activities to manage the Grant side of things and then include them in your Case directly rather than having to link Cases with CiviGrant.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-30T00:08:56.740Z
Answers.Text: I don't think so. I came across the same issue with some CiviCampaign based Activities - which meant they didn't work as expected in terms of user access (needed 'administer civicampaign') and Views didn't 'see' them. But that said, it is just a field in the db which you could try setting directly there?
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-30T21:27:41.080Z
Answers.Text: I was actually exploring this and realized that although there activities types associated with various components (Grant, contribution, etc.)  The Activity type and option UI only lets let's you create custom Contact and Case type activities.  Am I missing this somewhere?
Answers.UserDisplayName: Sonicthoughts
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-29T10:35:32.450Z
Answers.LastActivityDate: 2015-07-29T10:35:32.450Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>I'm exploring Civicrm for a client that processes emergency grants for individuals with medical, and other issues.  There is a process to fill out forms which often requires follow-up in the workflow.  </p>
  
  <p>For the architecture, I plan to use grants (and the grant application extension) to collect and approve grant applications (since this is designed with financial accounting in mind) but also create a case and activities to manage the application process (followup, approval, etc.).</p>
  
  <p>There is a close entity relationship between the grant application and the Case.  Since civicrm does not (yet) have entity relationship or lookup custom fields, does anyone have a suggestion of how to approach this relatively simple requirement?  Basically, Grants and Cases would each have a reciprocal field to connect each other. </p>
  
  <p>I'm sure the "answer" will require creating an extension (would prefer to avoid maintaining it).  I could also do this in Drupal with entities / views / rules but wondering if there are any other clever approaches.  </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-29T02:17:38.603Z
Comments.Text: I haven't really grappled with CiviGrant but we have set up a useable Grant Application process purely with custom Activities which I presume you could then include in your Case rather than having to link them. Might that help? but perhaps your relationship between Case and Grant is not one-to-one?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-29T03:23:21.783Z
Comments.Text: Clever!  I may go that route although CiviGrant does have nice financial integration which is relevant (and this is actually for a grant ...) Will look at the tradeoffs
Comments.UserDisplayName: Sonicthoughts
Tags: <civicase><evaluating-civicrm><civigrant>
Title: Entity Relationship Between Grant and Case
ThreadText: # Entity Relationship Between Grant and Case
  
  (Asked by: username_0 on 2015-07-28)
  
  I'm exploring Civicrm for a client that processes emergency grants for individuals with medical, and other issues. There is a process to fill out forms which often requires follow-up in the workflow.
  
  For the architecture, I plan to use grants (and the grant application extension) to collect and approve grant applications (since this is designed with financial accounting in mind) but also create a case and activities to manage the application process (followup, approval, etc.).
  
  There is a close entity relationship between the grant application and the Case. Since civicrm does not (yet) have entity relationship or lookup custom fields, does anyone have a suggestion of how to approach this relatively simple requirement? Basically, Grants and Cases would each have a reciprocal field to connect each other.
  
  I'm sure the "answer" will require creating an extension (would prefer to avoid maintaining it). I could also do this in Drupal with entities / views / rules but wondering if there are any other clever approaches.
  
  **Tags:** civicase, evaluating-civicrm, civigrant
  
  > **Comments:**
  > **username_1**: I haven't really grappled with CiviGrant but we have set up a useable Grant Application process purely with custom Activities which I presume you could then include in your Case rather than having to link them. Might that help? but perhaps your relationship between Case and Grant is not one-to-one?  
  > **username_0**: Clever!  I may go that route although CiviGrant does have nice financial integration which is relevant (and this is actually for a grant ...) Will look at the tradeoffs  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2015-07-29. Score: 2 | Accepted answer
  
  If you are using Drupal as your CMS then one option would be to set-up a webform that simultaneously opens a case and a grant (yes, webforms can do both at once). In that case the webform submission itself could serve as the link between the two, or you could make a more explicit link via custom fields.
  
  > **Comments:**
  > **username_0**: Nice idea!  When you say "you could make a more explicit link via custom fields" would that be to record the Grant/Case ID or somehow build a link?  
  > **username_2**: Storing the id in a custom field would require custom code, probably in a _post hook, unless you just do it manually each time. So if you're going to that trouble you might as well make it a link not just an id.  
  
  ---
  
  ### Answer by username_1 on 2015-07-29. Score: 1
  
  One option would be to create your own custom Activities to manage the Grant side of things and then include them in your Case directly rather than having to link Cases with CiviGrant.
  
  > **Comments:**
  > **username_0**: I was actually exploring this and realized that although there activities types associated with various components (Grant, contribution, etc.)  The Activity type and option UI only lets let's you create custom Contact and Case type activities.  Am I missing this somewhere?  
  > **username_1**: I don't think so. I came across the same issue with some CiviCampaign based Activities - which meant they didn't work as expected in terms of user access (needed 'administer civicampaign') and Views didn't 'see' them. But that said, it is just a field in the db which you could try setting directly there?  
  
  ---
  
  