Send Emails to a list of the application's users
Hello Everyone, I am currently writing a script that basically needs to send an email to a specific list of users. Given the user id, is there a way to access their account email address? Right now I have: for each m in Review_Board_Member [ID != 0] { sendmail ( To : m.User.[THIS IS WHERE I NEED HELP] From : zoho.adminuserid Subject : "Sweet" Message : "This works" ) }Also let me know if there are other problems with this code, all it's
how to add record via URL (http)?
hi there is website, which can send via http data from filled form website send it as "http call": http://my_site.com/?name=NAME&email=EMAIL@EMAIL.COM&phone=PHONE_NUMBER&lead_id=225298 http://my_site.com i can replace with http://creator.zoho.com/my_application/my_form/ how can tune my form so that it can record new entry when such "http call" from website is done?
Zoho Reports integration task for lookup field
Hi, I am using the integration task in order to add rows in zoho reports data base. I am using this kind of script: rowInfo.put("Email link Zoho", input.Email_link_Zoho); rowInfo.put("Horas Extra", input.Horas_Extra); rowInfo.put("Promedio Mensual Horas Extra", input.Promedio_Mesual_Horas_Extra.toString()); mapResponse = zoho.reports.createRow("Empleados Activos", "Empleados Activos", rowInfo); So far it works perfect except for the lookup fields, it returns the ID number and not the actual names
Zoho Capabilities - Multiple step/Multi party editing of data
Hello All, My client is in need of the following workflow: 1. A form is submitted outlining a new product idea 2. An email is sent to a preset list of emails saying something like, "A new idea was submitted you have x amount of time to respond to the idea with your thoughts, respond using this form (link to a response form). 3. The response forms simply edit the same table as the original request form - basically there is a column in the request table for each binary yes/no response from every notified
date validation between two date fields
I want to resolve exactly the same case herehttps://help.zoho.com/portal/en/community/topic/date-validation-between-two-date-fields I can not find where to setup this code? Where I should go to include code validation for a determined field Best Regards Natalia
Auto-fill date field UNLESS in Calendar view?
Hi, I have a date field in my form auto-populated to current date in the "on-load" function. This is great except for when I want to access the form from a Calendar report. I want to be able to click on the date in the Calendar (any date) and this date populates the date field. The only way I've been able to do that is to delete the on-load code. Is there a way to make it so that the date field auto-populates to the current date unless the form is loaded from calendar view? Thanks,
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:
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
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
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
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
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
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
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
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.
No permission to download document on portal
Hi I have shared access to a report setup on my app but when I try to download the document it says I am not allowed to download due to not having permissions to the view. Am I allowed to download a document on the portal if I am not a user. I have only shared the link through email and the end user has setup their account and can see the report but cannot download the document. Thanks
Subform auto population
I have a main form Purchase Order this contains a sub form, I am unsure on how to auto populate this sub form from a field on the same form, E.g; Suppliers Name on purchase form will automatically populate the sub form on row add. i haven't had any luck. Thanks
how to save a filter in creator's report?
made report with pivot table need to show at same time 1) filtered entries (column 2) 2) clear entries (column 3) how to apply & save custom filter for entries in column 2? see picture
Fetch Data from a form and input into a dropdown menu
I created a lookup field in form B called select event based on form A. After choosing the event, I want the registered names on form A to be listed in a dropdown menu or multi-select (Even better. For attendance taking purpose), is it possible? I tried using another lookup field for the names but it seems to give all the names for all events, I only want to the names from a specific event.
Save fields after submit
Hello, Can anyone help me with this; One of the fields on my form is a CRM field, after I select the SO number from the CRM it will auto fill the account name. I need to save the last two fields after I click submit record, so I don't have to re-select the same SO again. Doing this, because most of the time I'm using the same SO number to enter multiple records. CRM field name "Sales Order No." and zoho creator field that will auto fill is "Account Name".
opnURL with a NEW window works - but doesn't
I have a parent form where the user may select a Customer and (using OpenURL new window) can open a new window to view and edit that customer. I want the user to be able to go back to the parent form and select another user allowing him two Customer forms open. However - when he selects the second customer from the parent and issues the openURL (New Window command) the previous New Window is refreshed with the new Customer - a second new window is not opened - why?
"&" sign in drop-down show as "&"
Hi Zoho, On all of my drop-down menus, every "&" sign in my options it shown as & on the form live mode (screenshot attached). please fix this soon... Thanks Ravid
integration with crm - set crm-contact lookup field
I have a Billing application that I am creating in Zoho Creator. It will be called from the Contact record in CRM. My goal is to populate the CRM lookup fields in Creator with the proper values from CRM. When I use the following Deludge script in the onload event it does not populate the fields: hide ContactID; if (getFieldValue("ContactID") != "") { ContID = (getFieldValue("ContactID")).toLong(); contact = zoho.crm.getRecordById("Contacts", ContID); //alert(contact); bill =
Can I use :ui.add() function to add both dropdown code and description?
I am successfully built a dynamic drop down list using the :ui.add() function. However, does anyone know how do I control the dropdown code vs dropdown display value? The :ui.add() function seems to be able to work well for just the Code or it sets the generated HTML for Dropdown the same value for both code and description. The following is my code in the On User input trigger of the Country_Lookup field. The last statement will setup my State_Dropdown field dynamically. v_country_rec = Lookup_Codes
"unable to find subWeek" function" for a date variable?
Hi Zoho, I have a date field on the form, I've crated a dates list based on the date with addYear / addMonth. Now I'd like to insert records into another form, based on these dates. I have scripted: insert into Flags_n_Alerts [ LoanCompReq_ID = input.ID Popup_Date = EachReportDate.subWeek(3) Actual_Date = EachReportDate Project_Name = input.Project_Name ] Both Popup_Date and Actual_Date are date fields. On other cases, Actual_Date gets date variables and
Field disappeared, now not updating! please help...
Hi Zoho, In my application, on my Commercial_Terms_form form, I had a field named Project_Name. This field was used in a variety of scripts, but somehow it just disappeared - so I could not send the form, since it is mandatory. When I tried to add a new field under that name the system only allowed me to name the field "Project_Name1" (like there was already a field under that name - but there wasn't). Finally I have added this field on the "with action" script of the form, using the following script:
How to programatically update User field in a form
See the sample code below: for each o in New_Order [Order_Number == "352"] { info o.Order_Number + " " + o.Owner_Name + " " + o; o.Owner_Name = zoho.loginuser; } Owner_Name is a User field in the New_Order form. I tried multiple ways to update it but all failed: 1) zoho.loginuser 2) zoho.loginuserid 3) hardcoded string of my user name "lexshan8" 3) hardcoded string of my email "lex.shan@walkintour.com" What is it expecting? The error message is not helpful at all.
Next Page