formula url - creating blank record

Question

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???

joshuatate · Answer

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.

melissadoran · Answer

ok im just dumb i've done this before it's done from the relationships page. ignore me. lmao.

melissadoran · Answer

was just going to delete this but someone followed already haha i've been found out. too late haha

joshuatate · Answer

go for gold i unfollowed lol

Forum Discussion

formula url - creating blank record

4 Replies

Related Content

Create one Child Record per Year

Edit Record Formula Button

Creating Formula To Report

Records created in the last 24 hours

Help with Creating Formula

Recent Discussions

'Is Set' in Pipelines

Date value changes when copied to new table with pipeline.

Time of Day field values are not in 24-hour format in Pipelines

Create a formula duration over 5 years

Join multi-line text field to one line