ContributionsMost RecentMost LikesSolutionsButton to Initiate Windows Shell CommandIs it possible to create a button that will initiate a Windows shell command? If so, how do you do it? I am trying to automate a process that wouldadd a watermark to an existing pdf file attachment, then save it as a new revision. The watermark would be added using a program that can be accessed through the Windows command prompt using the original file name, output file name and properties of the watermark. The whole process would include placing the original file attachment where it can be accessed by the other program, issuing the command prompt command, then uploading the output as a revised file attachment. Does this even sound possible with Quick Base? Is there perhaps an alternate way to accomplish this? Re: How do I create a Formula-URL in a parent table to link to an attachment in specific child record?Great! This worked and did everything that I was looking for. Thank you.Re: How do I create a Formula-URL in a parent table to link to an attachment in specific child record?Thanks! I got it to work with this formula: URLRoot() & "up/" & [_DBID_ZWZ_Dwg_Revisions] & "/a/r" & [Maximum Record ID#] & "/e13/v0" You also accurately anticipated my next need: having the link display as the name of the file attachment rather than the actual link. How do I do this? Also, if the target field has no attachment, I'd like the result of the formula to be blank.How do I create a Formula-URL in a parent table to link to an attachment in specific child record?I would like to create a field in a parent table that displays a hyperlink to a file attachment in the most recent child record. I have already created a summary field that finds the Record ID# of the target child record. Knowing the child record ID and the field ID that holds the file attachment, how do I write the equation for the hyperlink?Re: How do I show records in reverse order in the record picker used in grid edit mode?Evan, The record picker is a drop down type. The situation is this: - Start on the form for editing a time card record. This form includes a table of individual time allocations that are related to the time card. - Click "Grid Edit" at the at the top of the table for related time allocations. We now see an editable table of the time allocations related to this time card and blank rows where new time allocations can be created. We want to add a new time allocation. - On the first blank row, double click on the cell for Related Time Card. At this point, a drop down list of all time cards appears with the most recent at the bottom of the list. Of course, it's one toward the bottom of the list that always needs to be selected. Changes that I make in the Time Card table advanced properties for fields to include in the record picker have an effect on the content shown, but I haven't found a way to reverse the order or use a report to populate the record picker. An alternative solution that would be great is to have the Related Time Card field automatically be set to the same value as all the others in the filtered list that the user sees. Any solutions you can offer are appreciated. Regards, DaveRe: How do I show records in reverse order in the record picker used in grid edit mode?Evan, Thanks for your response. I tried your suggestion, but it had no effect on the order of the records in the grid edit mode record picker. Any other ideas? Regards, DaveHow do I show records in reverse order in the record picker used in grid edit mode?I've tried making a report to use as the record picker, but grid edit seems to use the default record picker despite what I set up .