ContributionsMost RecentMost LikesSolutionsRe: Formula to look up a corresponding field from a related table?I have just discovered that you can create the standard relationship and then edit the related field type from number or text to formula and then set formula to the field where you enter the data manually. Have used it to update records with codes sent through an API to the descriptionRe: API Secure socket connect errorThank for your feedback, waiting for engineer to testAPI Secure socket connect error We are trying to connect to Quickbase from at mobile technical product through a modem so that we can registrer error codes etc. Our electronics engineer tested the script with ?Make HTTP Request?on https://www.hurl.it/ He is using a user token but is getting "Secure socket connect error" Script as follows: POSThttps://glovaas.quickbase.com/db/bnh95ctbw Content-Type: application/xml Content-Length: QUICKBASE-ACTION: API_AddRecord <qdbapi> <udata>mydata</udata> < usertoken > bygtji_upe_b???????????? </usertoken > <field fid="6">Test Message</field> <field fid="7">1234</field> </qdbapi> Any ideas I was unsure if the setting "Allow non-SSL (insecure) access via API" = Yes is the problem