ContributionsMost RecentMost LikesSolutionsRe: Summary Field values not importing via automation activated table to table importHey Mark, Not exactly sure what you mean. I don't have any "Current User" formulas or triggers anywhere for this - not in the Automation, the Import, or the Summary Fields. And I'm testing it, so in this case the current user, me, is also the owner of the Automation. If I manually trigger a Table-To-Table Import on the first table to copy the values from the Summary Fields to Static Numeric Fields in the same table, and THEN trigger the Automation to import those Numeric Fields' values to the second table, it works that way...so it appears to be an issue with copying the values from the summary fields specifically with the AutomationSummary Field values not importing via automation activated table to table importI have a Table set up for calculating employee's daily labor hours - This Table has severalSummary Fields that look up the duration of labor hours in various categories for the day. I have a Table-To-Table Import setup that copies the values from theseSummary Fields to another Table when the user checks a box to submit their labor hours for the day. This Table-To-Table Import works perfectly fine when I manually go in and click the "Import" button in the Import From Table interface within QB. The problem is, that when I assign thatTable-To-Table Import to an Automation and trigger it, the import creates the records, but will not copy the values from the Summary Fields. I have tried creating a Formula Fields in the first table that copy the values from the Summary Fields, and then using those formula fields in theTable-To-Table Import, that doesn't work either. Am I missing something?Re: Text centered in progress barSorry, I should have specified - I tried this, but it splits up the two bars and puts the text in a white space between them. I want the text overlaid over the two bars, with no space in-between. Maybe I just put it in the wrong spot? Here is the formula I tried: "<span style:align center><img height = 18 width="&$widthval & "src=\""&$box&"\"/>" & [Feeder Line %]*100 & "<img height = 18 width="&$widthvalbalance&"src=\""&$graybox&"\"/></span>" Text centered in progress barI have a Formula Rich text field set up that works as a progress bar - here is the formula: var text redbox = "https://lamresearch.quickbase.com/up/bpcve39mm/g/rd/eg/va/red.png"; // red var text yellowbox = "https://lamresearch.quickbase.com/up/bpcve39mm/g/re/eg/va/orange.png"; // yellow var text greenbox = "https://lamresearch.quickbase.com/up/bpcve39mm/g/rf/eg/va/green.png"; // green var text graybox = "https://lamresearch.quickbase.com/up/bpcve39mm/g/rg/eg/va/grey.png"; // gray var text box = If([Feeder Line %]<0.4,$redbox, If([Feeder Line %]<0.7,$yellowbox,$greenbox)); var text widthval ="\"" &Min(Max([Feeder Line %]*100,0),100)&"\""; var text widthvalbalance ="\"" &ToText(Max(0,Min(100,100-([Feeder Line %]*100))))&"\""; "<img height = 18 width="&$widthval & "src=\""&$box&"\"/>" &"<img height = 18 width="&$widthvalbalance&"src=\""&$graybox&"\"/>" I want to display the % (Feeder Line %]*100) centered in this progress bar, where/how would I go about doing this?Can a formula be used to obtain the number of slides in a PowerPoint?Either attached in QB, or from a URL?Re: Need to copy value in one field to another when a status field changes all within the same recordChanged the field type from Work Date to Date - it works now :) Thank you so much!Re: Need to copy value in one field to another when a status field changes all within the same recordImport Style: -Merge in Ops, [Op ID#] = [Op ID#] Import ops that meet the following criteria - Show ops where: -all of these conditions are true -[Related Project ID#] is equal to the value in the field [Related Project ID# of Focus Project] Yes, the child records have the correct [Related Project ID#] If I manually click the Import button, I get a green box pop-up that says "A total of 139 Ops were read in.139 existing Ops were left unchanged." Re: Need to copy value in one field to another when a status field changes all within the same recordWhen run manually, I do not see a pop-up - just the "Last Run Time" update The[Record ID# of Focus Project] field has the correct ID#, and is updating correctly the[Link to Focus Project (=1)] has a formula in it of 1, and is showing a value of 1 for all ops I could give you access to my app if that makes this easierRe: Need to copy value in one field to another when a status field changes all within the same recordNot quite working but I feel like I'm at least making some progress now, thanks! I have most of that working, it appears up to the part where it copies the value from [Actual Start] to [Planned Start]. The Automation triggers, the[Record ID# of Focus Project] gets set to the correct Record ID#, the import runs but doesn't actually copy any data it appears? Thanks again for your help so far!Re: Need to copy value in one field to another when a status field changes all within the same recordOf course! I appreciate the help - I have a parent table called Projects that has a child table called Ops -The Projects table has a field called Status, this field can either have the value "Not Started" or "In-Progress" -TheOpstable has a field calledActual Start and another field calledPlanned Start -When I change theStatus field in theProjects table from "Not Started" to "In-Progress", I want the value in theActual Startfield in theOps Table to populate thePlanned Start field also in theOpsTable, for eachOp related to saidProject. The Automation that I am trying looks like this: Trigger: When a user modifies a record in theProjects table <and>Status changes <and>Status is equal to the value "In-Progress" Action: Modify records in theOps table whereRelated Project ID# is equal to the value Project ID#, populate the fieldPlanned Start inOps > Value from another record > (I only see fields from theProjects table to select here, I need the field being copied from to be theActual Start field from theOps table I tried to work around this by creating aProject Status Lookup field in theOps table, then changed the Automation to: Trigger: When a user modifies a record in theOpstable <and> ModuleStatuschanges <and> ModuleStatus is equal to the value "In-Progress" Action: Modify records in theOpstable whereOP ID#is equal to the valueOP ID#, populate the fieldPlanned StartinOps> Value from another record >Actual Start inOps This seems to me like it should work, but the action doesn't even run - I'm assuming this is because a user (me) isn't actually modifying any records inOps, it's just the lookup fieldModuleStatusinOps changing to match the "In-Progress" value in theStatus field inProjects It seems like this would be easy to do - am I missing something really simple?