Parameters

NAME

DESCRIPTION

REQUIRED

URL/API

db

Table dbid where master data comes from.

EX: db= " &dbid() or db=xyzcdsd"

Required

Both

rid

Record ID# of record where master data lives.

EX: rid= " &[Record ID#] or rid=16"

Either rid or query required

Both

query

For records where master data lives.

EX: query={'16'.EX. ' " &[Record ID#]&"'} "

Limitation: A Button can generate up to 50 documents at once.

Either rid or query required

Both

name

File name of generated document

Required

Both

wep

WEP Templates dbid

Not Required

Both

weptbl

WEP Table dbid

Not Required

Both

weprid

Record ID# of template will be used

Required

Both

wf

File attachment field id when document generated as “Word” OR create a record in another table:

add|dest dbid|field mapping|file attachment field id|doc date field id

Example: wf =add|abcsdef|6:~3~.7:~10~.9:~7~.11:~21~|18|119"Field Mapping: Destination field ID:~Source Field ID~ Source field ids come from master table.

Not Required

Both

ef

File attachment field id when document generated as “Excel” OR create a record in another table:

add|dest dbid|field mapping|file attachment field id

Not Required

Both

pf

File attachment field id when document generated as “PDF” OR create a record in another table:

add|dest dbid|field mapping|file attachment field ID

Not Required

Both

doctdt

Date/Time field id to see when document was generated

Not Required

Both

addbefore

dbid|query|fafid|Sorting field ID

WEP Forms get multiple files, add in front of generated document. File(s) must be either word or pdf. This also can be used for just merging files without generating documents(with “mrg” parameter).

Not Required

Both

addafter

dbid|query|fafid|Sorting field ID

WEP Forms get multiple files, add to end of generated document. File(s) must be either word or pdf.This also can be used for just merging files without generating documents(with “mrg” parameter).

Not Required

Both

mrg

dbid|rid|fafid|merged filename|merge date

WEP Forms can generate multiple documents based on query and stores in Quickbase. WEP Forms can merge word or pdf documents.This also can be used with “addafter” and/or” addbefore” for just merging pdf or word files(from file attachments). File Merger(without generating documents) works only with API .

Not Required

Both

stsfid

dbid|rid|status field id

This can be used only for WEP Forms API

Not Required

API Only

weptoken

We create and update an "Application Variable" in your application. This variable is updated twice a day, but you can request more frequent updates. When the WEP Token is updated, the button URL will also be updated, and the previous URL will expire automatically. This helps make WEP Forms more secure.

You need to use it in your button as shown below:

&"&weptoken="&URLEncode([WEP Forms Token])

Required

URL(Button) Only