Home page URL in Button bar to autocreate record in a table

OK, well who are we to question why you want to add blank records :)

Where is says in your formula 

[_DBID_MY_TABLE_ID]

What you need to do is to go to the target table where the record is to be added and settings and advanced properties and at the bottom it will give the table ID such as

_DBID_ORDERS

That is what goes in the square bracket so the formula URL know which in which table to add the the record.

The correct DBID is in there, I just removed it from this example and replaced it with [_DBID_MY_TABLE_ID]

OK, well I doubt the error message is in error.  There must be a field named what the error message says in the table you are adding a record to.   Do you have the correct DBID?  ie are you adding records to the the table you intended.

I think the error is because you have a custom-key field or a required field in the table that will prevent you from adding a blank record if it is not filled in.  Check your field-list to see what fields have asterisks beside them.  Make those required on your form layout; rather than at the field-level.

I have the correct DBID, and that field is not in that table.

I removed that field anyways to see what would happen and I get "error code 0". "No error". Works fine as a formula field, just not as a home page URL button.

When clicked as a formula field on a record  you should not see any system response, just a page refresh.

I usually do like

act=API_AddRecord

but I doubt that is the problem.

It should work, but I'm not sure right now why it's not working.  I would first get it working as a formula field on a form.

I don't get a system response when used on a record, I've stated it works as a formula field in my original post. Just not as dashboard homepage.

I'm not sure why either, but thank you anyways.  _\_(_)_/__

I think it's something to do w/ the javascript in the button, though I couldn't say exactly what.

I would create a report on the table that has the working formula URL button, including a single record and the button as the only column, and put that report on the dashboard.

That was going to be my workaround, and as QuickBasePros_IDS pointed out, turns out it did have something to do with the javascript.