A form button that will force record add on a specific form.

Question

I have a tasks table, but I want to allow users to enter simple tasks or complex tasks. One form for simple tasks and another for complex tasks.

This works for complex tasks and is the default form for all roles.

URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm&_fid_145=" & URLEncode ([Project Number])& "&z=" & Rurl()

I am trying this one for simple tasks, but it still loads the complex tasks form (ID=11) even though the URL says form ID 16.

URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm&_fid_16=" & URLEncode ([Project Number])& "&z=" & Rurl()

Also, this latter one is not loading the related project like the first one does.

There has to be a simple way to load form 16 even though it is not the default for all roles.

MarkShnierYou · Answer

This is the syntax you need

URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm&_fid_145=" & URLEncode ([Project Number]) & "&dfid=16"

& "&z=" & Rurl()

In my mind when I type dfid I mentally think "da form ID" spoken like a Chicago gangster.

Sign up