I am looking for a way within a formula that is called from a button to assign a record ID from a query to a variable.

  • 0
  • 1
  • Question
  • Updated 3 years ago

I am attempting to query a record in a target table by the related record id from the source table and store the rid number in a variable.  I am however getting an error stating the data type declared does not match the return type. 

var Number TxID = URLRoot() & "db/" & [_DBID_INVENTORY_TRANSACTIONS] & "?a=API_DoQuery&includeRids=1" &
"&query={'5'.EX.[Record ID#]}" &
"&z=" & Rurl();

Photo of Justry Weir

Justry Weir

  • 10 Points

Posted 3 years ago

  • 0
  • 1

Be the first to post a reply!