Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.8K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
How to use the API_EditRecord to make date field blank
Dean Ousterhout
03-31-2019 15:22
I need to set a Date/timedate field to blank using the APi_EditRecord and i have not figured it out. ...
QuickBaseCoach Dev./Training
03-31-2019 15:25
Here is an example. You just end the = and say nothing else. urlroot() & "db/" & dbid() & ...
Dean Ousterhout
03-31-2019 15:30
Thanks Coach.
Jon Froderberg
02-23-2024 11:02
This approach worked best for my application. Thanks Coach! ------------------------------ Jon Froderberg ...
Dean Ousterhout
03-31-2019 15:30
Well, operator error. I specified the field incorrectly. it needs to be _fid_44=NULL ... this wo ...
QuickBaseCoach Dev./Training
03-31-2019 15:31
I suppose that works as well.
1.
How to use the API_EditRecord to make date field blank
1
Like
Dean Ousterhout
Posted 03-31-2019 15:22
Reply
Reply Privately
Options Dropdown
I need to set a Date/timedate field to blank using the APi_EditRecord and i have not figured it out. I tried _fid44=0, ='', =' ', =NULL, etc.
What is the secret sauce?
Thanks,
Dean
2.
RE: How to use the API_EditRecord to make date field blank
0
Like
QuickBaseCoach Dev./Training
Posted 03-31-2019 15:25
Reply
Reply Privately
Options Dropdown
Here is an example. You just end the = and say nothing else.
urlroot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID]
& "&_fid_44="
3.
RE: How to use the API_EditRecord to make date field blank
0
Like
Dean Ousterhout
Posted 03-31-2019 15:30
Reply
Reply Privately
Options Dropdown
Thanks Coach.
4.
RE: How to use the API_EditRecord to make date field blank
0
Like
Jon Froderberg
Posted 02-23-2024 11:02
Reply
Reply Privately
Options Dropdown
This approach worked best for my application. Thanks Coach!
------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.com
Portland, OR
801.946.0576
------------------------------
Original Message
Original Message:
Sent: 03-31-2019 15:25
From: QuickBaseCoach Dev./Training
Subject: How to use the API_EditRecord to make date field blank
Here is an example. You just end the = and say nothing else.
urlroot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID]
& "&_fid_44="
5.
RE: How to use the API_EditRecord to make date field blank
0
Like
Dean Ousterhout
Posted 03-31-2019 15:30
Reply
Reply Privately
Options Dropdown
Well, operator error. I specified the field incorrectly. it needs to be _fid_44=NULL ... this works.
6.
RE: How to use the API_EditRecord to make date field blank
0
Like
QuickBaseCoach Dev./Training
Posted 03-31-2019 15:31
Reply
Reply Privately
Options Dropdown
I suppose that works as well.
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic