Forum Widgets
Recent Discussions
Looking for formula help
I am trying to write a formula that will subtract to date fields only when certain conditions are met. The fields for the conditions are checkbox fields. The formula field I started below is numeric. This formula works without the conditions of the checkbox fields. If([RX Ready Date]<[Plan Set -Up All],0,(not IsNull([RX Ready Date])),ToDays(([RX Ready Date]-[Plan Set -Up All]))) I want to add to the formula to only subtract the dates when [Pharmacy], true and [Fast Track] is false (both checkbox fields). Any help to add in the conditions is much appreciated.
Populating Child Table Date Field to Parent Record
I have a Parent/Child table relationship for two tables. On the Child table there is a date field that I would like to populate up to the Parent table for use on every new child record in the Child table. Do I need to create a new one to many relationship for the current child table to the current Parent table flipping them in this new relationship or can this be done in the current relationsip? Thanks Brian
Help! Formula Query with multiple conditions.
My query is not returning any value for records that meet the conditions. ToNumber(ToText(GetFieldValues(GetRecords("{86.EX.'"&true&"'}" & "{15.EX.'"&[mhe_type]&"'}", [_DBID_BTS_METRICS]), 10))) I need to return the field value (fid 10) from the table [_DBID_BTS_METRICS] when field ID 86 in the queried table is true (checkbox is checked) and the value in field ID 15 is equal to the value in the field [mhe_type] in the querying table. I have tried: punctuation, format, etc numerous times using a text field to give the checkbox a yes/no value and using that field (fid 89) in the conditions in case it is the checkbox giving me the problem changing it to a SumValues query, but then it returned a value of 0.
Map Report
I would love to use a map report to see how many clients come from each zip code, but currently the map will only show the first 100 clients. Is there a workaround for this where I could have each pin represent 50 clients? Or even just have one pin per zip code and hovering over will show the number of clients? I would really love to be able to have a visual element for this data, and my current summary report is long and clunky. Thank you so much! ------------------------------ Hunter Collins ------------------------------Dashboard Maps are actually awesome
Just FYI, and not a question ..... I just did my first production map report with hundreds of pins ( 610 pins to be exact!) on the Dashboard and OMG, you really have to give Quickbase credit for this one. The map loads super fast and as advertised, I was able to customize the pin colour and pin icon. They also did quite a nice job of handling the situation where multiple pins are at the exact same address. Kudos to some unknown software engineers and Product Manager for nailing this one. ------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------
