Dates Between
Good day, I have a form that receive StartDate and EndDate I need to create a record for each date between StartDate and EndDate how I iterate each date to build the insert into?. Thank you,
Reorder Multi Select Values
Hi, I have a Multi Select Field and it is working good. Sometimes I need to rearrange the order of the Selected Values in the Multi Select Field for some reason for instance if three Values have been selected in the order Val-01, Val-02, Val-03 .. Then If I need to rearrange that order like Val-03, Val-02, Val-01. What I have to do is delete all selected Records first then again select those three entries in the order that I want to achieve -Val-03, Val-02, Val-01.--. What would be great if there
Subform only works in Mobile App
I have created a subform to sort data on the back end as we process orders. The subform has a status field with a drop down but when I try to edit that field in the report in order to sort submissions I receive an error stating "You can submit this form only through the Zoho Creator App" Is there any way to get around this?
Auto identify subform rows
I am just starting with Zoho Creator. T have a form Jobs with a Job_No field (year & job No). There is a subform Labor. I want to populate a field Job_No in Labor with the Jobs Job_No every time a row is added. Please Help alexscott@btl.net
fetch records
I have two forms in an application. One is called Asset List and the Other Asset Manager. Asset Manager has a field called 'Asset Scan' which scans a bar code. Asset list has a field called 'ID Tag' which lists all of the codes which may appear in Asset scan. How do i fetch the description, depot, serial number and model from the Asset List form and place this as text in a separate field called Asset Details which is in the Asset Manager form, based on the Asset Scan being the same as the ID Tag?
How do I use 3 iterated records to filter a larger list?
I have a large "Price" form with the following fields: Product Date Terminal Price Then I have a form for "Customer" which has the following fields: Customer Name Products Terminals There is also a "Product" and "Terminal" table with additional details. What I Want to Do: I want to create pricing so that it only shows prices for the customer when the prices match their "Product" AND "Terminal". I have tried a lot of things but I am stuck. Any ideas on how to do this? Any help would be FANTASTIC!
Error Messages
I'm a complete beginner and am just trying to get to grips with zoho creator. However I'm finding it very frustrating as when I try to add coding which is identical to the examples given in the guide I get error messages e.g. adding an email notification to a schedule sendmail [ from: gillgannon12@gmail to: thegannons@eircom.net subject: "Birthday Alert" message: "Happy Birthday <br />" ] gives an error on line 2, improper statement, even though I used the 'send email' drag and drop! How can a bracket
Modified_Time is not updated in the case of bidirectional relationship lookup fields
"Enable bidirectional relationship" option in lookup fields is a great feature, but I think that there is still a problem related to it. Let me start with an example: I have a form named Participants and another one Workshops. In the Participants form I have a lookup field named ChooseWorkshop - which refer to a field WorkshopName in Workshops form. I enabled the bidirectional relation in the ChooseWorkshop field, so a lookup field WorkshopParticipants is created in Workshop form. The WorkshopParticipants
URGENT: Is sendmail working for other users?
sendmail stopped working this morning in our production code. I wrote this simple test function just to see if emails are being sent. They are NOT. I checked my account usage, I'm not over my email quota. void WalkIn.OM.Temp.Test() { sendmail ( To : "lex.shan@walkintour.com" From : zoho.loginuserid Subject : "zoho testing email subject" Message : "zoho testing email body" ) }
Rich-text field deluge
Hi A quick question- is 'on user input' deluge not possible for Rich-Text fields? I only see 'On update'.
How can i show lookup field id
How can i show lookup field id inside any module
Record Access Based on User
I have searched the forums but do not see an answer to this. I need to restrict salespeople to only seeing and updating their own records only. Managers and Admins will be able to see all. But I do not want salespeople to be able to view/update others records. Is this possible? I know I can restrict by Groups but I need more granular control. Thanks in advance for any assistance.
External plugins iframe not working
I tried to use iframe(a widget) from external website in my zoho page. But it is not working. Please let me know what is the problem ? Regards, Webber
iframe issues
Hi, I have an HTML view which consists of two iframes. One frame is called "info" and another "question". In the question frame, the user can edit information via a creator form. When the user changes a value of a drop-downfield, an open_url function is activated that is supposed to open a web page in the "info" iframe. However, no matter what I try, the web page opens in a blank window. Below the code of the HTML view ____ <iframe name="info" src="https://www.surfgroepen.nl/sites/Q-inspire/QDST/qdst-NL/pro-con-q-formats/dive-general.htm"
OnValidate
Hello everyone. You can use alerts and cancel Submit in native modules (Leads, Accounts ...?, If it's possible, how it would be. I welcome your comments. Regards
Need help with multi-select deluge
Hi I've been struggling with deluge for a multi-select lookup field. I've two forms- "Email_Recepient" and "Miscellaneous_Settings". "Email_To" is a multi-select field in "Miscellaneous_Settings" which is a lookup on "Recipient_Email" field in "Email_Recepient". "Recipient_Email" is the other field in "Email_Recepient". Idea is to let the client decide whom they want emails to be sent to for each submission (of a third form) by collecting the emails in a "Multi_Line" field in "Miscellaneous_Settings"
how to autorefresh Date_Time in views of zoho creator reports?
hi! made report when i open entry - i can change Date_time field. This field depends on system current time. is it possible autorefresh this field in view without openning entry? example 1) i open this view and see list of entries 2) for each entry there is own Date_time setting 3) after 10 minutes in browser window i refresh this view 4) after refreshing - for each entry their settings of Date_time has increased at 10 minutes each
Feature Updates Page
https://www.zoho.com/creator/help/general/feature-updates-and-bug-fixes.html This was updated through July but seems to have reverted back to April?
how to make search string - inside a form?
hi there is working form and there is database with about 1,500 records like "city - area" how can i in working form make a search string in which user enters first N characters of city name and below this search string appers a list with all cities which names correspond entered characters with ability to pick up city name see example from other website
New PDF engine
Hi, the new PDF engine caused total misconfiguration all our pdf pages. Anyone have experimented the same problem? Thanks Mike
Contact us form returns error.
I tried to fill out a contact us form and get this error. Looks like i'm expected to fill out a field for nr of users, but I see no such field.. Error found while adding the data... Please get back and rectify » [] 1 . No_of*Select a value for No. of Users .
I need help to understand "For each" and "Fetch Record"
I am following this tutorial: https://www.zoho.com/creator/help/tutorials/add-advanced-scripting.html#enhancements and I am stuck with this excercise: //Set Total value with 0.0 USD input.Total = 0.0; //loop through all the selected Items and calculate total //"For each list" task is used for each itemID in input.Products { //Get the Product Row from the Products form //Fetch record task productRow = Products [ID == itemID]; //Calculate Total Price input.Total = (input.Total + productRow.Price);
Footer with paging numbers
I know that this question is quite old (as I find it in the forum the last years) but as an update, does anyone of you found a hack way to create paging footer? Something like 1/5, 2/5 etc in each page.. I know how to create sticky footer but what about paging?
"Sort by" in reports not working?
Hi Zoho, I'm trying to sort my Flags_n_Alerts report in my app, I try to sort the report by Added Date and by Recepient, the added date and time sorting is only sorting by the time (meaning 12:00 tomorrow will be higher ranked than 17:00 today) and the text sorting is not working at all.... Please fix Thanks Ravid
how do I make a subform show multiple records that were already added according to an action in the mainform?
Hi! I have an application with the following forms: Products Purchase Order Purchased Products Sales Orders The Purchase Order form has the "Purchased Products" as a subform. The "Purchased Products" form has lookup field from Products. So the user loads the form Purchase Order, clicks on Add New "Purchase Products", selects the product and add the purchasing price and quantity. Then other fields as Subtotal and Total are updated on the form "Purchase Order". So far so good. Now, my problem is on
Fetch Record ID then automatically email link
Hi I've been searching for hours for an answer to this question but with no luck. I've created a form that once submitted fetches an email address and emails the user, but what I want to do is include a link to the record that has just been created for editing. The form is used for a business to record times of jobs beginnings and ends. So once the job has been submitted it automatically gets sent to the user and they must click the link go in and update the times and resubmit the form. I know how
Zoho CRM Resports Not Working At All
Noticed today that when you click on the "Reports" tab/link it just keeps loading and loading and loading... it's happening in both "new" and old Zoho CRM. I can't run ANY type of reports now :-(
Custom related
HI, I am afraid I don't I have created 3 custom related list (or I am wrong). Where can I check the corresponding "custom related list" Thanks! Andy
Form Builder
Hi, Question 1: I am building a form, And there is 1 dropdown. When I am using Zoho Creator iPhone application, after selecting an option from dropdown, I have to click "Done", is there any option or code which can auto close the dropdown, and go back to the form after selecting any 1 option from dropdown, and do not need to click "Done" in iPhone Zoho application. Question 2: In a same form which I mentioned in Question 1, I have added Radio buttons' group which is in 3 columns format. But in iPhone
iCal option for timezone?
When I add an iCal feed to an Outlook calendar it shows the event at GMT. In the Zoho app the time zone is set for EST (New York). Outlook shows the event time 4 hours later than in Zoho. Is there an iCal option to indicate the time zone offset? Here is an example of the feed https://creatorexport.zoho.com/zoho_admin3897/appowner/ical/appname/4PsSWBXKUx16BJK0dfQ0G6h8OOakkyBztZwg8ewY0JHD44B3XKSVsHZsfbMWdGFwQpFSpx7n3m0HeuR68sF8y7ZPayJC72s2F9Rv/DTSTART=Next_Contact_Date_Time&DTEND=Next_Contact_Date_Time&SUMMARY=iCal_Display&Record_Owner_Company_Link.Email=bryan@domain.com
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
Duplicate a Form in a same Application
How can i duplicate a form in the same application I want to use the same extructure of a existent form for another one! Tnks! noduscol.noduscolombia.co
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
How to switch to Developer edition ?
Hi, I just finished the free trial edition of Zoho Creator. My account automatically switched to the Free version. Since I can't use subforms with free edition, I would like to use the Developer edition. I'm in the developing phase of my project and I don't want to spend money until the app is ready to use. I can't figure how to convert an existing free edition account to a developer edition. The following link allow new user to signup to developper edition : https://www.zoho.com/creator/developers/signup.html
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
Users Add-on at $1/user for Enterprise Edition
Up until now, subscribers of Enterprise Edition had to contact our sales team to add more users to their account at $3.5/user. We have now slashed the price and made it a much more simpler process. Using our newly introduced User Add-on , Enterprise Edition users can now purchase more users at $1/user directly. To add more users, go to your Subscription tab . If you are in Enterprise Edition, click on "Manage" under that edition and if you are in other editions, click on "Upgrade" corresponding
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,
New BETA features being released in the next couple of Months...
Hi Folks Just spoke with Anbu at Zoho Creator Support and he gave me a little heads up on the Beta features being released in the next couple of months. Sandbox (the ability to develop and then push to live production) New live UI (a more flat more modern user interface design. With a lot of javascript goodness I hope) New form builder (haven't heard about this one before) Page Builder (this will allow a better HTML page design experience) Page builder - Customer Portal (not sure about this one)
Next Page