ChrisChappell
Qrew Member
Joined 7 years ago
User Profile
User Widgets
Contributions
Copy record and edit (URL)
I have created a URL to copy the record the user is in, however, it stays on the original record. Is there any way to change the formula to go to the new record once it's created? The formula is: URLRoot() & "db/" & Dbid() & "?act=API_AddRecord" & "&apptoken=psudc7dxr3x76cra11pz11raxm6a" & "&_fid_11=" & ToText([Related Record]) & "&_fid_10=" & "20" & "&_fid_6=" & ToFormattedText([Issue Date], "DDMMYYYY") & "&_fid_7=" & ToText([Reason]) & "&_fid_14=" & ToText([Survey Status]) &"disprec=1"; Thanks, Chris ------------------------------ Chris Chappell ------------------------------Zapier help! Adding a line in a child related to parent
I have a zapier Zap that sending an email with attachment to a table called "File Attachments". This table is related to a file attachments section in the parent. However, the related field "Job Number" will not change so that the new "File Attachment" line will show on the parent. Can anyone help, please?Drop down from another table with cross referenced field in seperate table
Hi, I have a job tracking table [Main Page] which has multiple codes that need to be associated with it. The [Main Page] draws a contract name from table [Contracts]. The code table [Synthetics] also has codes with associate Contract name from [Contracts]. It also contains Description, Unit and Price. The [Synthetics] table can have the multiples of the same [Synthetics] code number with a different price associated with it which is based on the [Contract]. In the [Main Page], I need to be able to select the relevant [Synthetics] in a drop down based on the [Contract] that has been allocated to the job. This will then show the code number, and the Description, Unit and Price, together which an open field to add the quantity of each [Synthetics] code. I have created an [Estimates] table which shows on the [Main Page] which looks at the [Synthetics] table and I can add multiple [Synthetics] codes against the individual job on the [Main Page] but the [Synthetics] list lists all of the codes, not just the ones based against the contract allocated. It feels that I almost need some sort of formula lookup stating "List [Synthetics]. WHERE [Synthetics].[Contract]=[Main Page].[Contract], but am unsure how this would work. I hope this makes sense and someone can help. Many thanks, Chris