How to include a link / response in email to update a field in record?
Hi there, My app "Booking Management" sends an email notification to "freelance clerks" with appointment details. They need to accept or decline this appointment. Email notification set up under deluge script - no problem. Custom action "accept" & "decline" in Zoho Creator report - no problem Now there is my problem - I would like to include the option to "accept" or "decline" in the email & update the record. I have set up a stateless form (link to main form create a booking) to embed in the email:
Keep Dashboard Updated
Hi, I created a dashboard in zoho reports and embeded it in zoho creator app. The graphics in the dashboard are based on the empleoyee management form which I created in Zoho Creator. How can I keep this dashboard updated? any help will be appreciated
Restrictions for the From address is not about security.
Dear Zoho Creator, I want to discuss a really annoying thing in Zoho Creator sendmail() function. You have these restrictions (https://www.zoho.com/creator/help/script/send-mail.html): The email sent will have the email id of the application owner or the email id of the login user, as the From address. If the From: address is not a zoho.adminuserid or zoho.loginuserid, the To: address can only be zoho.adminuserid and the sendmail task cannot have any CC: or BCC: address. Actually, this restriction
Suggested Practice for modifying in use application in creator
Our organization is using zoho creator in live production but we're always needing to make changes to the live version. Sometimes (often) it seems making some changes can "break" our work flow and causes pains. What is the best method for updating production apps in separate environment and then deploying? Right now we're able to "replicate" the app and the work from there but the data does not transpose we it's copied. I suppose two main questions: 1) Is their a way to more automatically transpose
unable to schedule quarterly task in "zoho creator"
how do i schedule a quarterly and semi-annual task in zoho creator
How do i change the currency format?
I would like to know how to change the Currency format. The default format is X,XXX.XX ; i need to use the Brazilian format currency X.XXX,XX The difference is how to use the "," and "." exactly the opposite. Thanks for any help!
Bulk Edit disable not working
Hi I have created an application in Zoho Creator and I want to restrict Bulk Edit in Reports. I have unchecked the Bulk Edit Record from Reports Setting -> Restrict Visibility but Bulk Edit is still enabled. Is there anything that I am missing.? Attaching screen shot for the same. Please advise. Thanks
Zoho (embed) + WordPress: Inherit WordPress Theme Style
We're new to Zoho -- We see it as an interesting solution to embed Zoho forms, views and repoorts in our WordPress sites, but not to use Zoho by itself (creator.zoho.com). We have been able to embed Zoho forms and views on WordPress pages. However, we notice the disparity between the Zoho themes and the WordPress themes. We, and our clients, like a consistent look and feel across a WordPress site. The embedded Zoho forms and views are functionally correct but aesthetically wrong. Is it possible for
How to add New Line Charachter in Zoho Creator using XML RPC API?
Hi, I am importing data through XML into zoho creator using xml rpc api, and it works very nicely. Now i want to insert a new line in long string text. Is this possible or not? I have tried alot, but getting no luck. Tried for new line like this: \n, <br>, <br/>, <br />, %OA, %OD. here is xml format: <ZohoCreator> <applicationlist> <application name="my-app"> <formlist> <form name="form-name"> <add> <field
Include empty values in pivot chart
Just wondering the following. I have created chart reports. The form it is based on a form with fields that can stay blank/empty. The chart ignores these fields. For example 1000 records with Gender field: 200 "Male", 300 "Female" and 500 left empty. The chart makes 100% of only the Male (40%) and Female (60%) together, but I would like it to be relative to the total records, so 20% Male, 30% Female and 50% null/empty/unknown. Is that possible? (note the chart also created a value "Unknown" but that
Customer Portal Add-On / Is this per "App" or per "Account" / what about sub-domains
Hi there, I would have 2 questions regarding the "Customer Portal Add-On"... as I'm just not not sure. 1. Is the Customer Portal Add-On per "App" or per "Account"? I see that within each App (under the same account) I can go to Customer Portal and see the provided URL is different. Clicking on that also sends me to the Login Page. Considering this, I would assume that that once you have the "Customer Portal Add-On" (for the 99$/month) this feature is now available for your ACCOUNT, i.e allowing for
Struggling to add a record to a form by email
1) I have a registration form on my website, from which I get an email whenever a record is added. I have mentioned the same mail ID (my Zoho mail account) as the form email alias for a Zoho Creator form. 2) I have setup a filter in my Zoho mail account to forward these mails to the form email ID. This is the process outlined in Latha's response at https://help.zoho.com/portal/en/community/topic/how-may-set-the-form-email-address-for-adding-form-data-by-email But this process breaks down for me
HTML Image Tag
Hi, I'm a bit stumped on this, and I hoped you might be able to help me? I'm trying to learn how to display external images in Creator. I have a form called "Images". It has a formula field which has this expression: "<img src='http://help.zoho.com/portal/en/community/images/imgLogoAdmin.gif' />" But when I look at the view, it has a broken image icon. I can't get any external image to work. I'm a bit puzzled, I'm afraid I just can't see what I might have missed. I wondered if you could help? Many
Cannot share application with a user becauser names do not match
A user registered in Zoho has the email address "sos@mydomain.com" and full name "SOS". I share a Zoho Creator report with user sos@mydomain.com. Zoho Creator shows that the report is shared with "sos1". I log into Zoho Creator as sos@mydomain.com and try to open the application. I receive the error: This application is not accessible. Sorry sos2, you are not allowed to access [database name]. Please contact this application's administrator. The application is not accessible because the report is
Zoho Creator page take data from form
Hello. I am using Zoho Creator, but not Zoho Invoice. However, some related functions are being done through Creator. I created a page using the "invoice template" from in the pages settings / templates. How do I draw the data from one specific form to populate that invoice? I've changed the variables correspondingly, but I don't know how to invoke the data from one particular entry from a form.
how to add entries via email - when using email forwarding on email server?
hi! just made form to add entries via email all works well task - add entries when i send email to "order@mailserver.com" on "order@mailserver.com" there is forwarding rule - all inbound emails send to creator form's email rule is turned on when i send directly to creator form's email - entry is in when i send "order@mailserver.com" - there is no entries how to add entries when using forwarding?
Cannot email data into zoho form using email id alias
Please this is an urgent issue. I need to have users who are NOT registered to Zoho email data into a form. I have set the email id alias of the form to an authorized email account and tried setting the forwarding address on my email client to the zoho email id. I keep getting the authorization error.
Rich Text Fields skewing Reports
Hi, I have used RTF's and I need to be able to have my user view the RTF when they want but the default behaviour of the RTF forces the rows ot the report to be almost unusable. Does anyone know of a way to create a hyperlink to the actual RTF or some other way of limiting the size of the RTF in report view? Thanks
Show uploaded image in page
On my report I have a link to a page in a popup which displays an image that was added to each record. The page opens in the popup correctly but the image doesn't display; the HTTP request for the image returns "500 (Internal Server Error)". I also tried using a formula to show the image, like I saw mentioned somewhere, but I get similar results. Here is the page that I have: htmlpage View_Image(recordId, imageNumber) displayname = "View Image" content <%{ record = My_Stuff [ID == input.recordId.toLong()];
Help with Global Variable
Hello. I've read the article on Global Variables, but something isn't clicking for me. The article describes adding 2 form fields, which I really don't need. I have a Start_Date field on a Add_Student form that I want to write to a variable globalStartDate. I will then access that variable from an HTML page named Certifications and perform a run time calculation. What is the best way to do this?
How disable mandatory when a field is hidden/disable
Hello, I've a form with a radio button, when we select a word, the form hide/show different field but I want place a mandatory on field, but if the field is hide/disable I can't send form because madatory of this field creat problem. Thank you
ZOHO Creator native mobile version - configuration & push notification
Hi I have 2 questions with regards to Mobile app for ZOHO creator: 1. Are we able to configure the screens we see by default when we download the ZOHO Creator mobile apps? If can, may I know where is configuration function to do so 2. How to set a push notification on the mobile app so that whenever say a record gets added, it notifies the user via the mobile app. Thanks! Boon Yar
How to hide data in look-up field - using criteria hold in main form from previous records?
I am working on an application to book services and assign them to employees (employees are selected using a lookup field). * Booking form has : start date, end date, selected service, select employee --> drop-down lookup field (linking to add/edit employees) Once the worker is selected a decision box: "mark worker as busy" is ticked. ==> The idea is when the form is submitted, the employee is marked as busy for the period " start date - end date" * Add/edit employees form is used to hold: Name,
Can you sum fields in a subform and input them into the main form before successful submission?
Can you sum fields in a subform and input them into the main form before successful submission?
New UI sidebar Width
Hello, The new UI looks very good, however the sidebar is very small to show Forms Full Names. An option to change its width along the application is highly appreciated. Thanks
"Variable ID is not defined" when filtering a report to send on email?
Hi Zoho, I have a scheduled task, that runs through a form's data and adds entry IDs to a list (SentMsgs). Than, I'd like to send a report to the admin, showing only the entries that their IDs were added to the SentMsgs list. I have scripted: sendmail [ from:zoho.adminuserid to:zoho.adminuserid subject:"Monday emails report" message:"Hi Self, <br><br> Monday emails report attached.<br><br> Enjoy!" content type:HTML attachments :view:Flags_n_Alerts_Report[SentMsgs.contains(ID)] as PDF ] But when I
New Creator App Portal Design
Hello, The new design deployed this weekend takes up to much screen real estate. We run scores of apps that need constant management and the list view with search was the most efficient way to drill down to the application needed. Please modify to allow a list or panel view depending on preference. Please return the list narrowing search box! Also the ability to not duplicate applications would be a deal killer! We need that function back! We use a template app and then copy it for our projects.
View complete working ZOHO database off-line
I want to show my complete working ZOHO databases to some important military visitors from their Embassy in Washington, D.C. this August at Camp Atterbury, Indiana. The camp does not have available WIFI, nor can a civilian computer be connected to their lines. I visited the camp yesterday, and on the one available military computer, I was able to pull up my extensive website (www.IndianaMilitary.org), but when I selected, within that web site, to view the ZOHO database, they would not load. Just
Counter for number of characters in a multi-line field
Hi, how do I add a counter to show the number of characters in a multi-line field in real-time, meaning, as the user types into it. I'm using Length function as a formula field but the problem with it is the user needs to move out of the multi-line field in question for the counter to update the value. Hence looking for a more ideal solution.
How to fetch and update records from a sub-form in another form
Hi, how to fetch and update records from a sub-form in another form?
why do I get error maximum number of api calls reached?
see error message. I think it has something to do with my account but I don't know exactly what i need.. Thanks, Boudewijn
Deleting an application
I tried to delete the application OFFLINE SERVICES AND ASSET TRACKING (PREV LIVE) but was getting error messages around my functions so I deleted all the functions and forms manually. When I try and remove the application, I get the following error message Error Occurred. We are sorry for the inconvenience. Can you please remove the application?
Unhide a column in a view
Hello, how can we unhide a column in a view that was hidden by mistake (and report has been saved) Luis
hide a column in when pusblighing a report
Hi, I want to pusblish a report that has a column hidden. I can't find a way to hide a column in the options available when publishing a report. The reason is that the column is used to filter the report using deluge code but the user don't need to see this. thanks a lot. Luis
ical feed and view link
The instructions to create an iCal feed is to go to the report in live mode and click on Links. With the new interface the Links link does not show. Is there another place to get the formatted iCal feed?
[Question Update a field (Look-Up)
Hello i don't understand how I can Show/Hide data in lookup field in function of radio button field ? I want select a choose in radio button and lookup upadate from "Contains" like : - I select "aircraft" - Lookup update in function of field "type_vehicle" contains "AIRC" - I select "car" - Lookup update in function of field "type_vehicle" contains "CAR_DATA" Thank you ! Josselin ROBIN
[Question] How we can export application
How I can "give" application on other account ?
Lookup fields which are linked to main fields
I have a products page which has the name of the supplier and then an item code, in another purchase order form i have a sub form that contains the products page. What I am trying to do is get it so that only the items from the companies display in the subform as a drop down. simpler way of putting it Car makes and Car Models only display the models which are grouped with the Make.
Tips on modifying an HTML Page with existing embedded reports. ??
I'm looking to try and place 4 reports into 4 equal quadrants on the page for a more effective view for my customers. Any help is greatly appreciated.
STRING and right expression is of type BIGINTLIST and the operator == is not valid
Hi, In Criteria left expression is of type STRING and right expression is of type BIGINTLIST and the operator == is not valid Status = Volunteer_Registation [Name == Select_Volunteer]; Status.Hours_Volunteered = input.Add_Volunteered_Hours; How can I solve this?
Next Page