ContributionsMost RecentMost LikesSolutionsRe: Logging edit history for Numeric FieldIt Worked by using Dynamic Form Rule. Thank You...Re: Logging edit history for Numeric FieldWhile creating Automation > Actions > Filter Records : I don't want any filter condition to be applied. If at all i applied any filter condition, the number of records automation has to be applied is becoming more than 1000. My Automation has failed with the following error: ActionExecutionException: Number of records returned exceeded max of 1000. Is there any other way ?Re: Logging edit history for Numeric FieldYes, Using Automation i can log the last updated value but not the previous values before the last updated value. Is there a way to log all the edit history for that field ?Logging edit history for Numeric FieldI want to log the edit history for a Numeric field. I tried creating FORMULA-TEXT field. But using that i can log only last edit details. But i want to log all the edit history for that Numeric Field. Currently QuickBase supports logging edits only for Text Fields. Is there any way i can do that for a Numeric Field. Also, i dont want the user to see that edit history on the form. I want the edit history to be visible to Admin only. Re: Formula URL button using Javascript to display the count of records in a Table using API_DoQueryCountYes, Its working but the URL of API_DoQueryCount contains single quotes within the URL . It causes the error. So, i replaced with double quotes and by using ESCAPE CHARACTER(\). After that it worked fine. Thank you.. Re: Formula URL button using Javascript to display the count of records in a Table using API_DoQueryCountYes, I changed the urlD and urlE as per my tables and i inserted the above code into my Formula URL Field. In the Field properties, i have selected "Display as button on forms and reports". Now on the form its is showing as a button but when i click on the button its not working. I mean its not clickable and it is not updating the count value to a field. My doubt here is that the output of Formula URL button should be a URL link. But here we are inserting Javascript code in the Formula URL which gives the output to be a JS Code instead of URL. I suspect it is the reason that the button is not working.Re: Formula URL button using Javascript to display the count of records in a Table using API_DoQueryCountHello Chayce, Thanks for your reply. Can you please provide any sample code for that .Re: How to automatically Copy records from Table1 to Table2 after applying filter on Table1.I want to obtain the record count before the import and store that count value in a field or in a variable.Re: How to automatically Copy records from Table1 to Table2 after applying filter on Table1.I got an issue in that... As i am looking up the Summary Field of FocusTable into the BaseTable, It is giving me the last updated value of Summary Field instead of current updated value. This is happening when i click on the Formula URL Button with the below formula: var text URLONE = URLRoot() & "db/" & [_DBID_FOCUS_TABLE] & "?act=API_EditRecord" & "&rid=1" & "&_fid_6=" & URLEncode([Article Number]); & "&apptoken=xxxxxxxx"; var text URLTWO = URLRoot() & "db/" & [_DBID_FOCUSMASTER] & "?act=API_EditRecord" & "&rid=1" & "&_fid_7=" & URLEncode([FocusMaster - Summary Field - # of Graphmasters]); var text URLTHREE = URLRoot() & "db/" & [_DBID_Table2] & "?act=API_RunImport&ID=43"; var text URLFOUR = URLRoot() & "db/" & [_DBID_Table2] & "?act=API_RunImport&ID=44"; var text URLFIVE = URLRoot() & "db/" & [_DBID_Table2] & "?act=API_RunImport&ID=45"; var text URLSIX = URLRoot() & "db/" & Dbid() & "?a=er&dfid=2&rid=" & ToText([RECORD ID#]) ; $URLONE & "&rdr=" & URLEncode($URLTWO) & URLEncode("&rdr=" & URLEncode($URLTHREE)) & URLEncode(URLEncode("&rdr=" & URLEncode($URLFOUR))) & URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIVE)))) & URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIX))))) Is there a way to get the current updated value ?? If not, Is there a way to use Javascript in Formula URL to extract the number of records in the Table using API_DoQueryCount ?Re: How to automatically Copy records from Table1 to Table2 after applying filter on Table1.I got an issue in that... As i am looking up the Summary Field of FocusTable into the BaseTable, It is giving me the last updated value of Summary Field instead of current updated value. This is happening when i click on the Formula URL Button with the below formula: var text URLONE = URLRoot() & "db/" & [_DBID_FOCUS_TABLE] & "?act=API_EditRecord" & "&rid=1" & "&_fid_6=" & URLEncode([Article Number]); & "&apptoken=xxxxxxxx"; var text URLTWO = URLRoot() & "db/" & [_DBID_FOCUSMASTER] & "?act=API_EditRecord" & "&rid=1" & "&_fid_7=" & URLEncode([FocusMaster - Summary Field - # of Graphmasters]); var text URLTHREE = URLRoot() & "db/" & [_DBID_Table2] & "?act=API_RunImport&ID=43"; var text URLFOUR = URLRoot() & "db/" & [_DBID_Table2] & "?act=API_RunImport&ID=44"; var text URLFIVE = URLRoot() & "db/" & [_DBID_Table2] & "?act=API_RunImport&ID=45"; var text URLSIX = URLRoot() & "db/" & Dbid() & "?a=er&dfid=2&rid=" & ToText([RECORD ID#]) ; $URLONE & "&rdr=" & URLEncode($URLTWO) & URLEncode("&rdr=" & URLEncode($URLTHREE)) & URLEncode(URLEncode("&rdr=" & URLEncode($URLFOUR))) & URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIVE)))) & URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIX))))) Is there a way to get the current updated value ?? If not, Is there a way to use Javascript in Formula URL to extract the number of records in the Table using API_DoQueryCount ?