User Profile

AlexBartholomew

Qrew Member

Joined 6 years ago

19 Posts

View All Badges

User Widgets

Contributions

Ongoing Schedual Calendar
Hello Everyone, Our food rescue picks up food from different stores in our city. We then partner with distribution sites that pick up food from us on specific days each week or month. Most of our sites are weekly; for example, they pick up every Tuesday. In other cases, the sites pick up on the fourth Thursday of the month. Is there a way to build or create a calendar where I can enter this data, and it generates all the sites and what day they would come to our location to pick up food? Currently, we have a table for each site with the day they would pick up and other additional information. I have attached an example of the calendar that we created in Excel. Thank you.
1 year ago Place Quickbase Discussions
other
Views
0likes
Comments
Re: API Button Help
Hello Mark, Sir, Thank you very much. I have been so flustered by this formula. Yet again, you have helped me through my challenge. Have a great day, sir!
1 year ago Place Quickbase Discussions
Views
0likes
Comments
Re: API Button Help
Hello Mark, So it is the connection from the parent table to the child. In the relationship, the Parent record ID on the child table is fid_15 which is the [Related Client], fid_18 is the [Client] name. Exposing the formula I'm getting either a 0 or (&_fid_15=&) or (&_fid_18&) into the next string. The [Related Client] is the numeric reference in the relationship. Which I would think is the right field to use. That worked in my other API button. The fid's are on the child table. I am on the parent table when clicking the button to populate on the child table. Does the order for fid's matter for API? If I hard code the Client's record ID # into fid_15, the call works perfectly. When I use [related client] the code says 0.
1 year ago Place Quickbase Discussions
Views
0likes
Comments
Re: API Button Help
Hello Mark, After fixing the & and $ error. My button is working. However I am trying to link my related client to this action and that part is not working. I have reposted the formula. Everything else is working correctly. Thank you. URLRoot() & "db/" & [_DBID_INTERACTIONS] & "?a=API_AddRecord&apptoken=b5398xucxejay4cqkqm3ecnzy964" & "&_fid_18=" & [Related Client] & "&_fid_7=" & "Savings Credit" & "&_fid_6=" & Today() & "&_fid_53=" & [Completion Percentage PM] & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl())
1 year ago Place Quickbase Discussions
Views
0likes
Comments
Re: API Button Help
I see one problem the fid_53 should have the & not the $.
1 year ago Place Quickbase Discussions
Views
0likes
Comments
Re: API Button Help
Hello Mark, I want to land back on the page I launched from. I also tried using the "&z=" & Rurl() which I thought would bring me back to the page I launched from. URLRoot() & "db/" & [_DBID_INTERACTIONS] & "?a=API_AddRecord&apptoken=b5398xucxejay4cqkqm3ecnzy964" & "&_fid_15=" & URLEncode([Related Client]) & "&_fid_7=" & "Savings Credit" & "&_fid_6=" & Today() & "$_fid_53=" & [Completion Percentage PM] & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()) Thank you for your help.
1 year ago Place Quickbase Discussions
Views
0likes
Comments
API Button Help
Hello Everyone, I have created an API button, but I keep getting an update_id error. Can someone please help me understand what this error means so I can fix it? Thank you -Bart <qdbapi> <action>API_AddRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>26238</rid> <update_id>1731629328550</update_id> </qdbapi>
Solved
1 year ago Place Quickbase Discussions
api
Views
0likes
Comments
Line Graph (y-axis numbers)
Does anyone know if there is a way to make the Y-axis numbers the same on line graphs? I have a screenshot of my graph, and the right side starts at zero and goes up by five. The left side is more bizarre and goes up by two then by three. The only number that is the same is fifteen. For us, this graph would make more sense if both sides had the same numbers. Thank you, Bart
1 year ago Place Quickbase Discussions
reports
Views
0likes
Comments
Re: Highlight Date fields that are blank.
Hello Shane, Thank you for the help. I have looked at and downloaded resources from QBJunkie. I'll look into recreating things from the exchange and see how that goes. I need to practice more with jinja, HTMl, pipelines and API's as I believe that as I can learn more we could gain more use out of QB. Thanks again. -Bart ------------------------------ Alex Bartholomew ------------------------------
3 years ago Place Quickbase Discussions
Views
0likes
Comment
Re: Highlight Date fields that are blank.
Hello Shane, That does work and I am able to put the formula-rich field next to the date field. I have one other question or ask. How or what is the best way to learn how to write HTML? I have been our QuickBase admin for over two years and have learned as I go with no background in computers or coding. If you have any suggestions I would truly appreciate it. Also thank you for taking the time to help me come to a conclusion. Have a great day. Thank you, Bart ------------------------------ Alex Bartholomew ------------------------------
3 years ago Place Quickbase Discussions
Views
0likes
Comments

Groups

App Builder Qrew
Are you a builder? This Qrew is for you. Come discuss all topics builder focused here.
27 Posts