MarkShnier__You
Qrew LegendJoined 7 years ago
User Profile
Qrew Legend
User Widgets
Contributions
Re: "Can not update built-in fields values."
In Quickbase, the most common situation is there are 5 built-in fields on every table. These cannot be edited as they are populated automatically. So these are feels like the date created, and the date modified, the record ID, and the user ID is who created the restaurant last modified the record. Can you tell us a little more about your app. Are there relationships between the tables? How many tables are there and what are the names of each table and how are they related?9Views0likes0CommentsRe: Can you click on a field within an email to update a quickbase form?
This formula tested OK. LMK if you need help with adjusting the color or the size of the button. var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_355=1" // replace the 355 with the field ID of your checkbox field & "&disprec=1" // this will land the user on the record after they click. & "&apptoken=xxxxxxxxx"; // in advanced settings for the app, you may have the need for application tokens enabled // I suggest that you disable this need, but if you do want to use application tokens //an extra layer of security, you will need to create an applicaiton token and supply it // here. "<a style=\"text-decoration:none; background: #1ba802; border-radius: 5px; color: #ffffff; display: inline-block; padding: 2px 2px 2px 2px; width:100px; text-align: center; text-shadow: none; border: 2px solid #1ba802; font-size: 12px \"href='" & $URL & "'>Approve</a>"0Views0likes0CommentsRe: Can you click on a field within an email to update a quickbase form?
Are you wanting to land the user on the record in edit mode and have them update a field and save. Or do you just want them to be able to click a button in the email to have the checkbox field get checked.17Views0likes0CommentsRe: Can you click on a field within an email to update a quickbase form?
Yes this is possible. you would need to make a formula URL button to edit the record and check the box and then land the user somewhere after clicking. The first step would be to build the button and get that working., Then step 2 is to format the button (if you care about the format) to look pretty in an email. I can help you with the formula URL button if you need help with that.33Views0likes0CommentsRe: Permissions - How can I keep my permissions as-is but allow for a specific field to be visible?
Unfortunately, a snapshot field of a look up field seems to behave to respect the permissions of the look up field so that won't work. But we can kind of build our own snapshot. I suggest you make a text field called like [Employee name.] Which has a similar name to the real. [Employee name] field and then use both a form rule, (and I would back that up with a pipeline) that says when the record is saved and the [Employee name.] is not equal to the value in [Employee name], then change the value of [Employee name.] to the value in the field [employee name]. You can initialize that frozen field by doing another look up of the employee name and then change the field type from being a look up field to just a text field. That's a quick way to populate all your existing records.6Views0likes1CommentRe: Save and Continue Issue
Congratulations. You head must hurt from all that banging against that wall. There may be a way to do what you want w.r.t. to keeping them in the popup, but I just noticed that there is a setting on the embedded report side panel setup for Open record in sub form Would it be a more consistent or at least an OK user experience to not open in the sub form (which I believe is the default) and just always keep them in full screen?10Views1like0CommentsRe: Save and Continue Issue
Try making a formula rich text button with this code. It should work in either edit or add modes. The code below works to add a record and then land the user on the newly added record in edit mode. var text RID = IF([Record ID#] >0, ToText([Record ID#]), "%%rid%%"); var text AddRecord = URLRoot() & "db/" & Dbid() & "?a=nwr"; var text EditRecord = URLRoot() & "db/" & Dbid() & "?a=er&rid=" ; var text URL = $AddRecord & "&rdr=" & URLEncode($EditRecord) & $RID; "<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #1ba802; border-radius: 5px; color: #ffffff; display: inline-block; padding: 0px 0px 0px 0px; width:100px; text-align: center; text-shadow: none; border: 2px solid #1ba802; font-size: 12px \"href='" & $URL & "'>Save and Continue Editing</a>" //NOTE: The %%RID%% does not seem to like being URLEncoded.14Views0likes0Comments