ContributionsMost RecentMost LikesSolutionsCreating Formula Multi-Select Field to Display Fiscal Years between 2 DatesMy dilemma is that I would like to create a formula multi-select field that shows which fiscal years the range between 2 dates contains. For instance, our fiscal years are between Sept 1st and August 31, If I have a Start Date of 09/01/2018 and 07/01/2020, I would like the formula multi-select field to display that this range is in FY19 FY20 FY21. My Initial thought was to somehow make a continuous if statement with the different Fiscal Year formulas, but I think that is inefficient. If anyone has any ideas I'd love to hear them. ------------------------------ Stephen ------------------------------ Table To Table Import - Pipelines SolutionHello all, A lot of you may already know this but the migration tool cannot recreate table-to-table imports in pipelines. When I asked the support group about this, they stated I would have to recreate the table-to-table solutions in pipelines. That was all well and good but we have 20 apps and each one has 4 or 5 imports that run daily. But after looking around a little I've found a simple solution. Schedule a Pipeline in the WebHook Channel: Make Request, and run the Quick Base API Call "API_RunImport" with the URL: https://target_domain/db/target_dbid?a=API_RunImport&id=10 &usertoken=user_token The dbid is the db when you're in the edit section of the table to table import you want to use, and the id is on the same URL line. I've tried it and it works. Re: Power Bi connection failureI'm having the same issue as everyone above. A lot of these reports are mission-critical so it would be great to have a solution very soon. ------------------------------ Stephen ------------------------------ Automations Phase - Pipelines Doesn't Do Certain TaskHuge Issue. With our applications, we rely a lot on table-to-table imports. Almost all of them have 4 or more imports that run daily. When trying to run the migration tool, I get an error of "Scheduled automation not supported." Also, id rather not have to create 40 table imports in pipelines across all of our apps. Is this being looked into or are we going to have to create these imports manually (which is a lot more complicated than in QuickBase), and then not have a way to run them automatically?Re: Child to Parent Multi Select Lookup FieldActually, I just got it, it was more simple than I thought of. Basically, it was just adding an intermediate table between the alliance and protocols table. I don't know why i didn't think of that.Child to Parent Multi Select Lookup FieldCurrently, I have a relationship that looks like this: Recently, we've come to the conclusion that protocols are going to be attributed to multiple alliances. but the way the current relationship works there can only be 1 related alliance to a protocol. If I was to make this a Many to Many I would lose the value of the alliance field, (id have to create a new alliance for every protocol. Is there a simple way I can get this done. Basically, all I am trying to achieve is to be able to multi-select 1 of 20 alliances from the alliance table and have the protocols linked to whatever I've chosen. That way when i look at the alliance table I can see a report link of the related protocols. I know I can make duplicate relationships but this number could grow to over 5 related alliances per protocol.Create Report from 2 Tablets Parent to ChildI need help creating a report from 2 related tables. Budget and Budget Amendments. The report i need would be a basic bar graph that will show Budgets Executed and Budget Amendments Executed over the course of 2 fiscal years. Currently, a budget can have several amendments, each of those amendments can be executed just like a budget. The bar graph I need will show a monthly view of the number of budgets that have been executed and the amount of amendments total that have been executed. I've created a Summary field that's is all budget amendments where the execution date is not blank but putting this in a report doesn't work right because it doesn't actually get a date from the amendments table. Can anyone help me with getting this report to work? I thought about doing this from the child table but I'm confused on how that would work. any help would be great.Re: Change multiple choice field by date entered in another fieldI see this as working moving forward but what about dates that have been previously entered, that won't have a trigger of an add or modify, the automation wouldn'tincorporate those. I would need to see what that status is on what we currently have in our database.Re: Change multiple choice field by date entered in another fieldThank you so much but with these actions will they be sequential. Meaning if someone edits and enters 3 dates will it pick the one closest to the top (formulaically speaking) to set the status as? To explain: If someone goes in and changes: Date 1 Date 2 Date 3 Will the status show as Date 3 instead of the other 2?Change multiple choice field by date entered in another fieldI would like to change a multiple choice field using the dates of another field. I know we can do this in one formulafield which I have done in other applications. However, I need it to be a multiple choice field because I will be creating a kanban report from that field. Is there a way i can use a formulatext field to manipulatethe fields. Something like this: If( not IsNull([1st Patient Enrolled]),[Milestone Status]=1st Patient Enrolled, not IsNull([Activation Date]),[Milestone Status]="Activation Date", not IsNull([Initial IRB/CIRB/SWOG Approval]),[Milestone Status]="Initial IRB/CIRB/SWOG Approval", I know there are form rules that change fields based on other fields but it is inconsistent and i needit to be in a specific order. Once again i know this can be done with aone formula text field but that field cannot be used with a kanban report. Any help you can provide will be greatly appreciated.