MikeTamoush
Qrew Commander
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Formula using Contain
Syntax is wrong. Try this: If( Contains([Account Name],"Wire") and Contains([Funding Indicator Name],"ASC") ,1,0 ) If this is a checkbox formula, you can also shortcut by only giving it the true option and eliminating the If statement all together. ie: Contains([Account Name],"Wire") and Contains([Funding Indicator Name],"ASC")12Views1like0CommentsRe: Dynamic Form Rules
What makes a user 'public'? Is it a role they are in? Or is this an EOTI table? Also, what exactly do you mean by 'had the reverse effect on all other projects'? Isn't this what you want, to NOT see tabs on an NDA project, then the reverse (to see tabs) on the other projects?11Views0likes0CommentsSave Before Navigating and API Edit Record Bug - Not bug...
I posted earlier about this and said I would update, but cannot find the original posting any more. I located what I felt was a bug, but Customer Service has stated is expected. This behavior may affect many of you, and I would be curious to know how many others have realized this is happening. When using SaveBeforeNavigating, if you have changed field values it is a random chance if the order will be: Save the Record and Grab the New Field Values or if it will be Grab Old Field Values then Save Record. Thus, you are are utilizing any changed fields (perhaps you are using an edit record api and taking the value of Field A, which was just changed), you will sometimes get the original value of Field A, and sometimes get the new value of field A. I guess both actions happen at the same time (grabbing the field values and saving the record), so it's a mini race to see which one happens first, and it switches back and forth. As they are labeling this as expected behavior, I suppose we will need to start a feedback if it is something we would like to see sequential (save then get field values). Wondering if others would be interested in this feature.9Views0likes0CommentsRe: An API(?) button to copy fields from the form, to other fields
This is the general code to create an API to edit the current record. This use a formula URL but you could use a formula Rich Text and create the button imagery yourself. URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=xxxxxxxxxxxxxxxxxxxxxx" & //your app token here "&_fid_6=0" & //sets a checkbox field to false "&_fid_7=" & URLEncode([Field A]) & //sets field 7 to field A "&_fid_8=" & URLEncode([Field B]) & //sets field 8 to field B "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])) //Redirect anywhere, this is to the record that was edited25Views0likes1CommentRe: Rename existing entries in a table
There is a find and replace function native in Quickbase. Create a report with all the records you want to change (in your case, likely you can simply use List All). Go to the 3 dots in the upper right and select 'Find and Replace in these records'.10Views1like0CommentsRe: Formula to populate a field based on another field that contains a specific text string?
If that is the only rule, then yes a simple 'Change Field 2 to 'Red Squadron' if Field One contains red, should work just fine. However, if there are lots of options (If field 1 contains blue, change field 2 to Blue Raspberry....etc), then I would first make a helper field called: [Word to Place in Field 2]. That would just be a long formula with all your possibilities, and then simply use that new field to fill in Field 2.7Views0likes0CommentsRe: Can I setup a reminder email to remind me on the date, instead of x days before or after?
I just set up a quick test and using '0 days before the date in the field...' worked for me (at least when clicking 'send test email'. I would have to wait until tomorrow to fully test....). I would double check your reminder email, and if it still isn't sending, check with Customer Support. If you want to test, just be sure to make a dummy record with todays date and put the 0 in and send a test email. Be sure to add a filter that ONLY sends your test record, or else every person with todays date will get the test email :)8Views0likes0Comments