ContributionsMost RecentMost LikesSolutionsDistinct Count on a combined text fieldI need to identify the number of unique inpatient admissions from claims data. Each inpatient stay can generate multiple claims each with a unique claim identifier. The claims would all share the same admit start date. the claim also has the member id of the member who had the inpatient stay. I want to count the number of inpatient visits visit for each member regardless of how many claims were submitted for the inpatient visit. I have attempted to do combine the claim ID with the admit date and want to do a distinct count of that.... ------------------------------ Lashell Thomas ------------------------------ Trying my luck again on this question....App A has a join table field for projects and organizations to allow multiple organizations to be added in an embedded form within App A. In each each join table in each App Project Field: Relates back to the "projects" table in the respective app Organization Field: App A (source of truth), App B - uses a connected table from App A Would like App B to use populate the field correctly when its information is imported to App A in a daily automation. Projects from App B are imported over to App A daily - should I create a relationship in App B to the the project table in App A or use the one in App B. The related project needs to match up in both Apps to make the import process work? ------------------------------ Lashell Thomas ------------------------------ I have ask this question before but didn't get a response back to my clarifying question...App A has a join table field for projects and organizations to allow multiple organizations to be added in an embedded form within App A. In each each join table in each App Project Field: Relates back to the "projects" table in the respective app Organization Field: App A (source of truth), App B - uses a connected table from App A Would like App B to use populate the field correctly when its information is imported to App A in a daily automation. Projects from App B are imported over to App A daily - should I create a relationship in App B to the the project table in App A or use the one in App B. The related project needs to match up in both Apps to make the import process work? ------------------------------ Lashell Thomas ------------------------------ Setting up a table with the right fields to allow for easy monthly trend of performance measuresFor a state - I want to show how did on a performance measure (there are about 9 performance measures) on a monthly basis. I am trying to figure out to best way to set-up the table, so that i can capture the measurement month, the state, the measurement, and the value - so I can created a monthly trend report for each of the 9 measures and see each state against together and separately. What is the best set-up for the table to make monthly entry as easy as possible. ------------------------------ Lashell Thomas ------------------------------ Re: How to create a new record button in a form to another table The table is another app... How would it change this guidance. Lashell NOTICE TO RECIPIENT OF INFORMATION: This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. This e-mail may also contain protected health information (PHI) with information about sensitive medical conditions, including, but not limited to, treatment for substance use disorders, behavioral health, HIV/AIDS, or pregnancy. This type of information may be protected by various federal and/or state laws which prohibit any further disclosure without the express written consent of the person to whom it pertains or as otherwise permitted by law. Any unauthorized further disclosure may be considered a violation of federal and/or state law. A general authorization for the release of medical or other information may NOT be sufficient consent for release of this type of information. Thank you, Aetna How to create a new record button in a form to another tableHow can add a "new record" button to another table with a form and have it populate a certain field from the from? So passing along the right value through the button url into the form? ------------------------------ Lashell Thomas ------------------------------ Imports + Join Tables - How to update a Join Table from a different QB appQuickBase A: Import "Project" from QuickBase B There is a join table in QuickBase A - that pulls "projects" and organizations together. "Organization" and "Projects" table is QuickBase A. I want the users in QuickBase B to be able to use the QuickBase A join table - to add an organization to the correct project (their project that was import into QuickBase A. Here is the catch - they would like to do this within their QuickBase B and not have to come over to QuickBase A to do this. I have a number of set-ups like this - so I want to learn the right approach - so I can replicate it. ------------------------------ Lashell Thomas ------------------------------ [Urgent] Reposting: Automation to create multiple records based on a multi-select text field using pipelineHow can create multiple records based on a multi-select text field using pipeline? So I can get the easy of a drop-down with the power of a join table.... If you can share the detailed solution that would be great.. Really need some help Lashell ------------------------------ Lashell Thomas ------------------------------ How to get answers to questions?Hi, I submitted two questions yesterday and did not get answers yet. Do I need to re-post them? Lashell ------------------------------ Lashell Thomas ------------------------------ Automation to create multiple records based on a multi-select text field using pipelineHow can create multiple records based on a multi-select text field using pipeline? So I can get the easy of a drop-down with the power of a join table.... If you can share the detailed solution that would be great.. Really need some help Lashell ------------------------------ Lashell Thomas ------------------------------