ContributionsMost RecentMost LikesSolutionsRe: Populating the most recent text from the child table to the parent tableOhh I see now! Awesome. Makes a lot of sense. Thank you sir! ------------------------------ Leo Leo ------------------------------ Re: Automatic Time/Date Stamp upon Saving a RecordWhat was the solution? ------------------------------ Leo Leo ------------------------------ Re: Populating the most recent text from the child table to the parent tableHi Mark, But what happens if the parent record is modify but no new comments were added at that point? Wouldn't the formula be broken since the last comment modified will not be equal to the last modify date on the record? I thought the solution might be to trim the last task or comment on a log field. Maybe I was not understanding the original question. ------------------------------ Leo Leo ------------------------------ Re: Populating another field from a selected Text - Multiple Choice fieldHi Delynn, Hope this helps. Create a one to many relationship between your tables: CONTACTS have many FORMS. Add the lookup phone number. When you enter a new form, all the contact options will be listed as a drop-down menu and the phone number will be auto populated based on your selection. ------------------------------ Leo Leo ------------------------------ Re: Is it possible to create a ""Save and Keep Working"" button from a formula URL field?So is there a way for this to do the following: I need a button (currently an URL Formula Field) to check a box and make another field blank while prompting a dialog box that will confirm we actually want to do this. It is working fine but if I make any changes to any other field prior to clicking this button I get an error. So maybe if the button can "save and keep working"and then check the box and then redirect, that might fix the issue? Formula being use right now below "javascript:if(confirm ('Are you sure you want to release this order?')){location.assign('/db/" & Dbid() & "?act=API_EditRecord&apptoken=xxxxxxxxxx&rid=" & [Record ID#] & "&_fid_234=1&_fid_605=&rdr=" & URLEncode(URLEncode(URLRoot() & "db/" & Dbid() & "?a=td") & "") & "')}" ------------------------------ Leo Leo ------------------------------ Re: How to enter both CSS and HTML in a rich text fieldWould you mind sharing a screenshot of the final result? I am curious of the capabilities of Quickbase when it comes to customizing something to this level. Thank you,Re: How do I automatically check a checkbox if [DATE] = the prior business day and uncheck the checkbox if [DATE] <> the prior business day?Question ... can i use this to automatically unchecked a checkbox? I need to create a checkbox field that has to be reset to unchecked the first of every month.Re: URL Formula to open file attachmentHi Keith, This works perfect when is empty, but when I have a file the link shows but with the formula. Is there any way for the formula not to show?Auto assign and create tasksWe have a table for Opportunities, and another table for Tasks (that has a relationship with the Opportunities table). What we need is for every time a new Opportunity is saves, and certain fields are selected, to auto create a Task assign to a specific user for him to approve. Is this possible? Thank you,Re: Multi-select field lookup does not exportany fix for this yet? it has been several month. Thank you.