Of course, since the primary column is Auto-Numbered, I can’t store my search text there, which results in me creating an empty record. As a feature request, would there be a way to store the search text in a column other than the primary column for the new record?
I’m not sure I understand what you mean. When you type in a search term and it’s not found, you’ll see the button “Add a new record”. When you click on it, you will not create an empty record but a row detail page will pop up, where you can fill in each column of that new record.
Normally the search text itself gets populated into the first column, so after a search, if no record is found, the search text becomes the start of the new record.
In the case described above (where the first column can’t take a string) the search text is discarded, although I would like it to be populated into a different column.
Say we implemented this feature. Now comes the next question: to which column would you like to populate your search term? Then there will be another dialogue, maybe a list of columns for you to choose with the mouse or keyboard. I’m not sure that’ll save your time rather than inputting that search term again in your desired column just as it is now. Would you agree?
Do it like thousands of other people who have used SeaTable to develop powerful processes and get their ideas and tasks done more efficiently.