ContributionsMost RecentMost LikesSolutionsHow lookup field based on a field in another tableHello I have three fields Site survey leads install I'm trying to get the field roof type from site survey to show in both commissions and install table and have the customer name to bring in the data to show the lookup field data that is already in the tables i.e the customer field. I want to have the account name auto generate that way I'm not always having to pick it out of the dropdown box. Is there a way to do this?? ------------------------------ BLAKE CARLSON ------------------------------Popups in Kanban When we move from one task to another, or from one lead processing to another, a box automatically pops up with notes asking why it is being moved from one to another. This would be from a kanban report. Is this possible? ------------------------------ BLAKE CARLSON ------------------------------ message popup boxHello, is there a way to code or make a popup box that you can converse with other users in? a lot like the support box you can click on to talk to someone on a website. using the @ to specify who your sending the message to and they would be able to send a message back to you. ------------------------------ BLAKE CARLSON ------------------------------ Re: keep getting error message when a record is modifiedi was able to figure it out thank you for your help Mark. ------------------------------ BLAKE CARLSON ------------------------------ Re: keep getting error message when a record is modifiedHow exactly do i do that?? ------------------------------ BLAKE CARLSON ------------------------------ keep getting error message when a record is modified Hello I keep getting this error message when I put the field as view only. <qdbapi> <action>API_EditRecord</action> <errcode>34</errcode> <errtext>You cannot change the value of this field</errtext> <errdetail>You do not have sufficient permission to set the value of the restricted field named "Morning Punch Time" with field id 7</errdetail> <rid>11</rid> <num_fields_changed>0</num_fields_changed> <update_id/> </qdbapi> This is the code for one of the buttons I'm using. is there a better way to do this so people aren't able to change the date and time after they have clocked in. If(IsNull([Morning Punch Time]), URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid="& [Record ID#] & "&_fid_7=" & URLEncode (Now()) &"&rdr=" & URLEncode(URLRoot()& "db/" & [_DBID_TIME_CARDS] & "?a=dr&rid=" & [Record ID#]), "javascript:alert('This has already logged in.')") ------------------------------ BLAKE CARLSON ------------------------------ Re: QB and SMSWhat field or fields do i need to make and how do i integrate them in an email?? ------------------------------ BLAKE CARLSON ------------------------------ Re: Status barsYes, once a job/task is finished the circles would turn green. ------------------------------ BLAKE CARLSON ------------------------------ Status barsTrying to make a status bar that updates as a task is completed. Attached is an example of what i'm trying to accomplish, if you can help that would be great. ------------------------------ BLAKE CARLSON ------------------------------