ROBERTVALENTINE
Qrew Trainee
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: Highlighting a file with a specific naming convention
I would suggest a formula checkbox to allow the records to self identify as needing to be checked. The formula could be a "If" statement checking the checkbox if whatever condition(s) you set on the file attachement field is true. Then just set row colorization in the report settings to color the row if your newly created checkbox is checked.6Views0likes0CommentsRe: Lock a relationship when creating new records
I can think of a couple ways to accomplish this, but if it were me I would probably just set up a Formula - Text field for the city and not even use the relationship. Something like this... Case( [Your facility name], "Facility 1", "Tulsa", "Facility 2", "Denver", null )12Views0likes0CommentsRe: How to create a save button to save a new record and then redirect to outside URL
Hi Paul! I found this on the QB Exchange (Magic Buttons) and it works perfectly for what I'm wanting to do. "<a class='Vibrant Success' href='javascript:LinkAway(\"" & "https://www.destinationswebpage.com"; & "\");' >Submit & redirect</a>" // This works because you have turned on the table's advance settings, "Save parent record automatically when a child record is created." // This also is borrowing the LinkAway that gets automatically added for formula url fields. We are invoking it here so when we are directed to the success.html page the record is first saved.17Views0likes0CommentsCheck a checkbox in table A if a condition in related table B is true
I have two tables: Table A is used to track vacations for our team. Table B is used for work shift scheduling I want to put a checkbox in the table B form that is automatically checked if that particular work day falls on a day that the corresponding employee is scheduled off because they have an approved vacation recorded on table A. So basically I think I need to write a formula that checks the table A and sees if that employee is scheduled off, and if so, checks the box on table B. But I have no idea how to accomplish this. Help?Add record from external application using AddRecord API
I'm relatively new to using APIs in my app, so forgive me if this is a REALLY simple thing. But basically I'm trying to put together a table that when a user "adds" a record by entering an order number into a field on the form, an API makes a call to an external app (that I've verified accepts API calls) and retrieves info for that order number, then adds it to the record, then displays it to the user. So the Quick Base app is basically functioning as a search/retrieve interface for the external application, in addition to logging all search requests. Is this even possible? And if so, where should I start?