ContributionsMost RecentMost LikesSolutionsRe: multiple reference criteria for a status icon fieldI created a bool to combine the two filing code fields, called "has no records filing code?" and is true when both fields are blank so working with that I tried this but I can't close it properly // Logic and UI Case ([has no records filing code?]=true, Case([Status], "Logging" , $LoggingHeader, "Allocated" , $AllocatedHeader, "Awaiting Reply", $AwaitReplyHeader, "Closed" , $ClosedHeader) , $RecordsHeader) ------------------------------ Owen Morgan ------------------------------ Re: multiple reference criteria for a status icon fieldthanks Don, I am not getting any closer I feel. It's a formula to determine the status header image The field is called [status header] I want it to show the formula based on the status field EXCEPT when there is a filing Code [Filing Code] or [Event – Filing Code] both text fields. I cannot make it work! AM I missing something obvious? Is there a better way to separate the override that the Filing Codes mean for the formula?? // Variable Images var text LoggingHeader = "<img src=\"https://****.quickbase.com/up/bp9dy8gr2/g/rb/eh/va/logging.jpg\", width=\"700\">"; var text AllocatedHeader = "<img src=\"https://****.quickbase.com/up/bp9dy8gr2/g/rc/eh/va/Allocated.jpg\", width=\"700\">"; var text AwaitReplyHeader = "<img src=\"https://****.quickbase.com/up/bp9dy8gr2/g/rc/eh/va/awaiting_reply.jpg\", width=\"700\">"; var text ClosedHeader = "<img src=\"https://****.quickbase.com/up/bp9dy8gr2/g/rc/eh/va/closed.jpg\", width=\"700\">"; var text RecordsHeader = "<img src=\"https://****.com/up/bp9dy8gr2/g/rc/eh/va/records.jpg\", width=\"700\">"; // Logic and UI Case ([Status], "Logging" , If (([Event - Filing Code])<>"" and ([Filing Code])<>"", $LoggingHeader, $RecordsHeader), $LoggingHeader, "Allocated" , If (([Event - Filing Code])<>"" and ([Filing Code])<>"", $AllocatedHeader, $RecordsHeader), $AllocatedHeader, "Awaiting Reply" , If (([Event - Filing Code])<>"" and ([Filing Code])<>"", $AwaitReplyHeader, $RecordsHeader), $AwaitReplyHeader, "Closed" , If (([Event - Filing Code])<>"" and ([Filing Code])<>"", $ClosedHeader, $RecordsHeader), $ClosedHeader) ------------------------------ Owen Morgan ------------------------------ Re: Downloading photos on mobile?No problem through the mobile app for me either sorry! The options you get when pressing share or download will probably vary based on the OS you are using as selecting share in my app (iphone) brings up iOS share/save options. You might need to try other devices to see how you get on. ------------------------------ Owen Morgan ------------------------------ Re: Downloading photos on mobile?Hi Mike It should be possible. I am able to upload and download files to QB records using the safari browser on an iPhone. Perhaps you can specify the device and browser you are using or state if you are using the App. Should certainly be possible. Owen ------------------------------ Owen Morgan ------------------------------ multiple reference criteria for a status icon fieldI have a status visual header for records. This works fine when only looking at one field [status] but I want to add an additional criteria. If [status] is closed AND [filing code] is not blank , show a different header. This is what I have Case([Status], "Logging","<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/rb/eh/va/logging.jpg\", width=\"700\">", "Allocated","<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/rc/eh/va/Allocated.jpg\", width=\"700\">", "Advice","<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/rc/eh/va/Allocated.jpg\", width=\"700\">", "Awaiting Reply","<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/rd/eh/va/awaiting_reply.jpg\", width=\"700\">", "Closed","<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/re/eh/va/closed.jpg\", width=\"700\">", If([Filing Code]<>"", "<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/rb/eh/va/records.jpg\", width=\"700\">", [Event - Filing Code]<>"", "<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/rb/eh/va/records.jpg\", width=\"700\">")) I tried closing the Case() before IF but then I get two versions of the image which is not right. in this scenario I am seeing the closed icon but not the records icon on cases that do meet the IF criteria Can i do this easily without creating a variable? ------------------------------ Owen Morgan ------------------------------ Re: URL Button Return URLThanks - I may try this ------------------------------ Owen Morgan ------------------------------ Re: Summary Report that counts occurences of multiselect itemsI think you might be right. I was trying to avoid having too many relationships if it wasn't necessary. Secondly because not all records have tags and some have just one and adding new ones is infrequent I like the simplicity of a simple search box without navigating away from the form ------------------------------ Owen Morgan ------------------------------ Summary Report that counts occurences of multiselect itemsIn addition to [type] and [category] we have [key terms] attached to [cases] Key Terms are not a relationship but are a tag applied, Key Terms are held in a seperate table {key terms} The [key terms] field is a multi-select text field which draws it data from the {key terms} table Some Cases will have 4 key terms eg [Case 1]: (topic a) (topic b) (event 1) [Case 2]: (topic a) [Case 3]: (topic b) (event 1) The Case records shows these as a list in the field but a summary report (with date parameters and based on combining equal values in the Key Terms field) sees these as different. I want a report that counts key terms that have occurred so the output from above would be Topic a = 2 Topic b = 2 Event 1 = 2 rather than seeing each set of terms as distinct. Do you think this is possible? bearing in mind that we will have around 50 new terms created per year and anyone could feature at any time ------------------------------ Owen Morgan ------------------------------ Re: URL Button Return URLThanks Mark, That's part of the challenge. There is no relationship between the tables. [Key Terms] is a field in [Cases] that draws from the Key Terms table into a multiselect field. They are effectively tags on a record. So there is no parent/child in the scenario. The formula as I posted has no return string, I left it empty as nothing I tried worked. Ideally a window would pop up and then the key term could be added. Would love to be able to add as multiselect works "add new choice" but that requires a relationship which is not really necessary Owen ------------------------------ Owen Morgan ------------------------------ Re: URL Button Return URL No ideally to the record they are starting from, or even more ideal, the box would be a popup ------Original Message------ When returning to the Cases table form, are you returning to a 'New Case' form with no record ID yet? ------------------------------ Brad Lemke ------------------------------