Discussions

Expand all | Collapse all

formula url - creating blank record

  • 1.  formula url - creating blank record

    Posted 02-23-2018 04:11
    Trying to create a child record from parent w/ formula URL button with key field of parent record prefilled, user to fill in other fields. 

    URLRoot() & "db/" & "DBID" & "?a=API_AddRecord&apptoken=TOKEN&_fid_11=" & ToText([Job Number])
    I've been playing with it, there are about 20 records that are just completely blank in all fields in the child table. Child table and parent tables are in two different apps. What am I missing???


  • 2.  RE: formula url - creating blank record

    Posted 02-23-2018 04:16
    you need to make sure the DB ID in the URL is the id for the application with the table you are adding the record to.


  • 3.  RE: formula url - creating blank record

    Posted 02-23-2018 04:29
    ok im just dumb i've done this before it's done from the relationships page. ignore me. lmao.


  • 4.  RE: formula url - creating blank record

    Posted 02-23-2018 04:30
    was just going to delete this but someone followed already haha i've been found out. too late haha


  • 5.  RE: formula url - creating blank record

    Posted 02-23-2018 05:35
    go for gold i unfollowed lol