ContributionsMost RecentMost LikesSolutionsMulti-Select Formula Field help I have a Multi-Select field [Badge:Patient Type] that is calculated through a relationship in a separate table. The resulting field could contain one or more of 30 different bubbles (terms). I need a formula that could look at that field and translate each term to a point value or number and add those numbers up. Example: [Badge:Patient Type] field contains the value ED; Clinic; OP [Specialty Points] field would contain a formula that said IF [Badge:Patient Type] contains "ED" then 3 PLUS if if contains Clinic, then 3 points, PLUS if it contains OP 1 point, etc. RESULT would equal 7 Is this possible or am I thinking of this all wrong. This is the formula I have so far: Sum(If( Contains( [Badge: Patient Type], "Inpatient"), 5)+ If( Contains( [Badge: Patient Type], "PF-Hospitalist"), 2)+ If( Contains( [Badge: Patient Type], "PF-Surgery"), 2)+ If( Contains( [Badge: Patient Type], "PF-Anesthesia"), 2)+ If( Contains( [Badge: Patient Type], "OPS"), 3)+ If( Contains( [Badge: Patient Type], "GI"), 1)+ If( Contains( [Badge: Patient Type], "Cath"), 1)+ If( Contains( [Badge: Patient Type], "Pain"), 1) If the underlined Patient types were found in the multi select field, then the answer would be 9 ------------------------------ Stacey Sexton ------------------------------ Re: Formula to Save & New while keeping fields from current recordThat worked beautifully! Thanks so much for your help. ------------------------------ Stacey Sexton ------------------------------ Formula to Save & New while keeping fields from current recordI am trying to write a url formula button that will allow the user to essentially Save the current record and create a new record while passing the data from fields 15, 7 and 9 to the new record. The user would end on the new record, ready to enter new data in other fields on the form, then be able to hit the button again repeat the same action, saving the current new record and passing fields 15, 7 and 9 to the next new record and so on. Is that possible or am I thinking about this incorrectly. I need users to log data, but want to save as many extra keystrokes as possible when the data does not change but every several records. thanks for your help. ------------------------------ Stacey Sexton ------------------------------ Place a Specific report in an Exact FormI have read through the online help with Exact forms, but I am still missing something. On my Form within the table, I can define a specific related report that I want to appear. In this case, it is a summary report from another table. It works beautifully. However, when I try to insert that field into my exact form, it pull ALL detail data which I don't want. Is there any way to create a formula that would allow me to put that same summary report into an exact form that I see in my table form? Thanks in advance for the guidance. ------------------------------ Stacey Sexton ------------------------------