Skip to main content
Question

Pre-populating fields if Save and Next is used

  • February 1, 2022
  • 0 replies
  • 32 views
Is it possible to setup some kind of rule where a particular field that was used in one record, that after clicking save and next, the field would auto-populate the field selection from the previous record?

------------------------------
Lance Cowley
------------------------------
This topic has been closed for replies.

QuickBaseJunkie
Forum|alt.badge.img+15
Not a 'rule', but if you create your own Save & New button you could use an API to do this.

In a formula URL field

URLRoot() & "db/" & Dbid() &
"?a=API_GenAddRecordForm" & 
"&_fid_8=" & URLEncode([Field 8]) &
"&_fid_9=" & URLEncode([Field 9])

Where _fid_8 and [Field 8] are updated per your requirements (same for field 9). The URLEncode may or may not be needed depending on the type of data being passed.

For a Save & Next (not Save & New) this would be much more challenging and the 'next' record could be any record depending on where the original record was accessed and the filtering/sorting on the report. In that case, the next record's ID would be used with API_EditRecord.

However, it could be done depending on the consistency in the workflow.

If you're interested in learning more about API buttons I have a course called the Secrets of API Buttons.

------------------------------
Quick Base Junkie
------------------------------
Terms & ConditionsAccessibility statement