Forum Discussion

GregSieber's avatar
GregSieber
Qrew Trainee
6 days ago

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

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.

 

 

formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 days ago

    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.