ContributionsMost RecentMost LikesSolutionsRe: Can I insert data into text lookup field ?Alright thanks for quick response!Can I insert data into text lookup field ?I want to insert data into a text lookup field usingAPI_EditRecord. Is there anyway this can be achieved? I tried to insert into lookup field but the lookup field remains blank.Re: How to use a formula field to query a table and insert field values into another table's fieldDo I need to be more clear with my question?Re: Create a sub total row in summary reportGaurav, were you able to implement a sub-total row?How to use a formula field to query a table and insert field values into another table's fieldI have two tables - "Task" and "Test" related as One-to-many( each task may have many tests). Test table has a field say "Name" that I populate using JavaScript from HTML page. Task01 has tests - Test01, Test02 and Test03 each test having a field(Name) - John, Austin and John respectively. I want to populate a field say "TaskName" in Task table with unique values from "Name" field in Test table. For example:TaskName in Task01 will have values - John, Austin. How can I achieve this using formula field to query Test table and insert values in Task table?Re: Add text to a text field without replacing the existing data and without the name - date stampingI am using Log edits so that when I click on Add button on HTML page, it appends the data to the data already present in the text field and not replace the existing data.Re: Add text to a text field without replacing the existing data and without the name - date stampingIn the image I shared; my multi-line text field (say [Data] ) already had data "John, Shawn, Josh". Then through the HTML page that I attached below, I add more data i.e. "6" and "9.2" to the same multi-line text field [Data] that gets added with date-name stamp. If I add more data i.e. "10"; it will get added to the same [Data] with date-time stamp and will look like this. John, Shawn, Josh [NOV-01-17 karan-bhavsar] 6 [NOV-01-17 karan-bhavsar] 9.2 [NOV-01-17 karan-bhavsar] 10 I want to replace the text inside square brackets along with the brackets with a comma so that I get this >> John, Shawn, Josh, 6, 9.2, 10 How can I achieve this using formula text field. ")Re: Add text to a text field without replacing the existing data and without the name - date stamping Ok, so I have to use an intermediate Formula Text Field and write a formula to replace the text inside square brackets along with the brackets with a comma. How can I achieve that?Add text to a text field without replacing the existing data and without the name - date stampingHow can I add text to a text field without replacing the existing data and without the name - date stamping ? (The data I want to add to text field is from Html page.)