ContributionsMost RecentMost LikesSolutionsRe: Calendar report to display multiple date fields To Chime in here..... Is this still the case 2 years later? ------------------------------ Eddy Elasmar ------------------------------ Transferring Ownership of a Connected Table Could be simple or major here.... The owner of a few of our connected tables has left the company. (I have his login if it helps) of the 5 he owns, 3 of them- I was able to simply "Use a different connection" which made me the new owner. However, 2 of them; when I change to myself, they error out trying to refresh. Error being "The resource '[[connection_176165]].[[bpqrpkjmt]]:ServiceDefinitionTable' does not exist." I believe it is because there are table to table relationships built off of the connected table. Could also be required or key fields are oddly causing it to error. Not sure what I am doing wrong... How can I transfer this to my name and have it refresh successfully? Thank You In Advance ------------------------------ Eddy Elasmar ------------------------------ File Attachments In Connected Tables Should be a simple fix that I cannot figure out for some reason... I have a connected table across two apps that mirror each other for much of their fields. Everything transfers over BUT file attachments carry over as text but not as an openable file. both fields are file attachments and both are linked though the connected table. I want it to be so when someone attaches a file in the main table... You can then open that file in the other app's connected table. see below snip for what the connected table looks like... it should be blue/a click to download. Thank You in advance... please help! ------------------------------ Eddy Elasmar ------------------------------ Re: KanBan Color Coding Based on a date passedMark, I am changes the status by dragging the record between the KanBan. I have tested it, it is still triggering normally and logging in the date as it would if I manually changed the dropdown. Do you know something I don't here? Thanks for all your help. Pretty long thread so I appreciate the quick turnaround ------------------------------ Eddy Elasmar ------------------------------ Re: KanBan Color Coding Based on a date passedI was actually able to use a dynamic form rule for this. I added another field copied from status. Names it shop status... When [Shop Status] IS NOT EQUAL TO "Blank" Action Change [Status Update] to "The value in Shop Status" Then unchecked the fire changed box. Yes ! Laura is awesome I am very familiar with her work. As she is mine. Thank you so much for your help. It works and looks awesome. ------------------------------ Eddy Elasmar ------------------------------ Re: KanBan Color Coding Based on a date passedMark, This looks very promising! I have 1 issue & 1 question. Issue: I now cannot select any type of status for the KanBan to be based off of. As we switched the [Status Update] log the time. Question: should the colors in your formula be HTML Color codes or just leave it as "Green" & quickbase will know what to do as it just generates the word "Green" rather than highlights a color is what I think would happen. Please advise Thank you very much for your time ------------------------------ Eddy Elasmar ------------------------------ Re: KanBan Color Coding Based on a date passedShop Status is a drop down field which contains: In Queue Pulling Cutting Milling Sealing Building/Boxing Complete & Ready to Ship When a project is "In Queue" - KanBan ticket is green always When a project is "Pulling" - Kanban ticket is green for the first 24 hours, yellow for the next 48, red after that When a project is "Cutting", "Milling", "Sealing", & "Building/Boxing" - Kanban ticket is green for the first 48 hours, yellow for next 48 hours, red after 96 hours. "ready to ship" green so basically each time that [Shop Status] Field changes, the timer needs to reset. Weather that could all be encoded or I need fields around that like i have currently a dynamic form rule to fill in a different field the date once [Shop Status]="Pulling" (Named those date fields: [Pulling Date Snapshot on Shop Status Change] - I know they're not technically snapshot fields... just dynamic form rules) This is what I have which is wrong and not much. Case([Shop Status],"In Queue","#23ff00", Case([Shop Status],"Pulling","#23ff00", Case([Shop Status],"Complete & Ready to Ship","#23ff00", if([Shop Status]="Pulling" & ([Pulling Date Snapshot on Shop Status Change] -today() >hours(0) & ([Pulling Date Snapshot on Shop Status Change] -today() >hours(48), "<div style=\"color:white;background-color:#9B0909;\">" & due: "&[Pulling Date Snapshot on Shop Status Change]" )))) ------------------------------ Eddy Elasmar ------------------------------ KanBan Color Coding Based on a date passedOh man do I need some help... I have a kanban that i am trying to color code based on a due date that has passed. So I have a status field and when that status changes to for example "Status 1", a dynamic form rule logs in the date in another field... based on that date, within 2 days, green. 4 days, yellow. so on, red.... BUT WHEN STATUS CHANGES to "Status 2" it logs in the date in a different field and the same concept applies. So I want the ticket colors to change based on how long a status has not been changes. Maybe I could change it so whenever status changes, it logs a new date in the same field. I am pretty lost and could use some help! Thank You in advance ------------------------------ Eddy Elasmar ------------------------------