Send information from one form to another via OnSuccess
Hey guys, We are making a multi-part form where our guys will fill out some base information and then select a category to be taken to a particular form based on the selection. We need a way to transfer the information from the fields in the first form to the form they are sent to. Thanks in advance!
Generate Part Number
Hello, How can I Generate Part Number From another fields and see it and add it to the ID part field Sample: Size: 2 1/2 Grade: Steel Weight: 23 Custom: 111 Result: 2 1/2 Steel 23 111 Thanks in advance / Omar
Lookup result not showing in export CSV files
Hello all, I have form A in which I enter a building number and save. On subsequent forms to reduce entry error I have a look up field to select the building from the already populated list. When I am checking the backups, I notice that the column which should hold that lookup result is blank. Is this a limitation or a bug? When exporting the list manually, the column shows with correct data. Just not in the combined Backup/Export version. Please help. Thanks, Scott
Problem with form mobile within an iframe in Chrome and IE
Hello When I try to open a form-mobile within an iframe I can see just the title. None of the fields are published. I happens in both, Crome and IE. In Firefox, however, it works OK. this is my page's code <html> <body> <iframe id='formulario_reservas' name='formulario_reservas' height='900px' width='100%' frameborder='0' allowTransparency='true' scrolling='no' src=https://creator.zoho.com/calterras/reservas-usategui/form-mobile/solicitar_reserva/></iframe> </html> you can try in this link http://ziaboga.com/usategui14/pzm.html
Second bigger record fetch
I have a form that contains kilometers and amount of fuel; I want extract the second bigger values from fetch for calculate: [ amount_fuel / ( bigger_kms - second_bigger_kms ) ]. My problem is find second bigger value. How can I do? Thanks
how to disable save entry on alert?
hi! just made alert On User Input example: if (input.datadostavki >= zoho.currentdate.addDay(3)) { alert("alert!"); } how can i disable save entry when there is true "if (input.datadostavki >= zoho.currentdate.addDay(3))" ? in this time user can see alert, close it and save changed entry i need when there is true "if (input.datadostavki >= zoho.currentdate.addDay(3))" - disable to user to save entry. please help to make this.
Zoho Creator Calendar View
Hi, I am trying to create an electronic Vacation Request form, but creating a Report in Calendar view does not seem to be working the way I want it to. If someone approves the vacation, it is then shown on the calendar, but say, the vacation starts on March 2nd and returns to work on March 14th, it only shows up on March 2nd with the details. Is there any way for it to show up on every day, including March 13th? Thank you in advance! Joy
Workflow Script to Reload a Form with Saved Field Values for Selected Fields
I'm new to Creator, and Deluge, and I'm trying to develop a workflow which I thought would be basic, but I need some help. When a user inputs values to one of the forms I've designed, I want the user to be able to select certain fields that do not reset their input values when the form is Submitted. Is there a field property somewhere that I can set so the form reloads with the last input value? Or must this be done with variables by storing the user's input during Validation and then retrieving
looking at existing clients
Hi In my application, the user can add new clients while looking at existing clients. Currently I am having trouble with fetching client information from the same form. I've had a look at these links but im not really sure how to implement/use these to make them workable in my application https://www.zoho.com/creator/help/script/fetch-records.html https://www.zoho.com/creator/help/script/fetch-a-value.html Thanks :)
iterate distinct records in one form and check a check box if it matches any distinct records in another list
iterate distinct records in one form and check a check box if it matches any distinct records in another list how do i do this?
Importing Data
Hi, When I import data (csv or excel), how do I import the data of a lookup field? Do I import using the related ID or do I import using the corresponding string. If I import using ID, does the format have to be number?
Is there a way to get usage metrics such as logins, pageviews?
We are aware we can get record create/update measurements with a crosstab report run daily that counts #records with modified within the last 24hrs, by user. Are there additional metrics available? Such as login or pageview logs or metrics? Thank you!
Record Summery Template absent
Hello, I would create a record template for a report. I created the Template in Form Setting. I don't know, now, how i can apply the Template. If I select the report, not appear "summary record Template", as explained at link https://www.zoho.com/creator/help/views/record-summary.html. In FORM Setting i can see "Record Templates", but is not present the field "active" or "inactive". 1) How I can Apply the template? 2) Can I insert in the Template a lookup field for select a customer and visualize
Migrate from FileMaker Pro on Mac
HI there, I am trying to import a database from FileMaker Pro to Zoho creator. if I export as xml or csv it doesn't work as we have more than 70 columns, so wanted to try to export from FileMaker Directly. But when i try to download the migration tool, the link is dead - https://www.zoho.com/creator/help/application/ms-access-and-excel-migration-tool.html and seems to point to the MS Access tool. How can I install the migration tool on my mac? Thanks
Power a number to a Decimal X^(1/8)
Good day, I try to raise a number to a power usin power(X,(1/8)), the problem is that the script tells me that the 2nd argument only can be a BIGINT, Could you please tell me which function should I use, Best Regards,
Linking two fields and forms
I have been trying to establish a relationship like the one in this example. I want to a record from a Look up field and fetch records from another Form and into these records into fields of the Same type and Name as the related Form. i am using script with my form and app names that looks like this: string externalapps.GetType(int name) { if (Enrollment_Information[ID == input.name].count() > 0) { return Enrollment_Information[ID == input.name].Dog_s_Name_1; } return
A function sends an automatic email with information from other fields
I made a button that automatically sends the customer a quote from a mailbox, the problem is that all the information of all entries is sent to that email. How I avoid that? void CORREO.Email2(Cotizador_Multiple CM) { String1 = ""; for each r in Cotizador_Multiple { String1 = String1 + CM.Articulos.Foto + CM.Articulos.Link + CM.Articulos.Precio + "<br>"; } sendmail ( To : CM.Email From : zoho.adminuserid Subject : "Prueba"
print in the background
hello, Is it possible to trigger a print job in the background (without any print dialog boxes)? Need to trigger the print job during a save event, and also via a custom hyperlink or button. Also, we will be triggering different print jobs for background printing - print a zoho record, print an image (via url), print a webpage (outside zoho). Is this possible? Thanks!
Insert Subform row On Success Action
Hi, I would like to insert row(s) of each Subform row into a form on Success Action of Main Form. Below is the script I was trying to but it not working correctly. for each selectedValue in input.Coverage.PCM_Fips { insert into MVPD_Partial_Coverage [ Added_User = zoho.loginuser MC_TVStation = input.Coverage.PCM_TVStation MC_MVPD = input.Coverage.PCM_MVPD MC_ChannelType = "0.1" MC_Fips = selectedValue ] } Note: PCM_Fips is the MultiSelect
How do I enable decimals in my "Price" field?
I can't seem to figure out how to enable decimals on my Price field in my Product Subform. The inserted products all have prices with two decimals, but once I've selected a product in the "New order" form, it shows its respective price rounded up or downwards, depending of course if the decimal being higher or lower than 0.5. The Field Deluge Name is linked to the actual Price, though.
Record Summaries missing!
When I duplicate my program, all my record summaries vanish! Please tell me this is supported!
Allow function to run when some details are missing
Hello all I have created the attached function and I would like to run it for a collection of records, however some records are missing the inputs for the fields needed to run the function. Is it possible to code the function such that when there is no input in the field, the function skips that record and carries on to the next record? Ideally, it should also insert a comment to the form stating which record was lacking input in which field. Here is my function: float calculateKVGunder25(Client_Details
Schedule a custom Function and run it daily
Hi, I am trying to run the below function on a daily basis.It is possible by using Scheduler in Zoho Creator ? void MVPD.AddUpdateLink_SubchnnelMVPD() { for each rec in Not_1_MVPD sort by Added_Time desc range from 1 to 500 { link01 = "<a href='https://creator.zoho.com/mikekokernak/across-platforms-web-proxy/Not_1_MVPD/record-edit/Not_1_MVPD_Report/"; link02 = rec.ID; link03 = ("' target='_blank' title='Click to Update Record'>Update Record</a>");
Updating string field based on lookup field
I have a form with a look up called "Customer" What I want to do is when a user selects a certain customer, I want the customer information that is tied to the selected customer (on the form the look up points to) to be inserted into the "Address" string field. How can I do this? Thank you in advanced
Signature Html
Good day, How do I put the signature captured in a form in a Html Page? Best Regards,
Linking data from two forms, each located in different application
Dear Creator community, Hello :) My situation is as follow: I have one application which contains a form with customer data: Application A, Form A: Row: Customer ID, First Name, Last Name Application B, Form B Row: Customer ID (look up field to Application A, Form A ,Customer ID) First Name, Last Name Application A is my master database, while application B is a secondary database created per user The desired process is as follows: I register a new user in application A database then, when i create
How do I allow duplicate entries of products?
I want to link or restrict all my individual products to their respective suppliers, so that when I select a supplier in, for instance, a purchase subform, only the products of that particular supplier show and not the entire list of products. In addition, I need to allow duplicate product entries, as several suppliers often produce a product that has the same name (in this case, a type of wine, based on the same grape), but is entirely different by nature. Many thanks in advance!
Lookup filtering and subform
Hello, could you help me? I've a form (i.e. customer) with subform(i.e. cars). in another form, I need to filter lookup CARS when I choose the CUSTOMER. How can I do it? I already seen the link, but it don't help me. Will place an example for clarity FORM A Customer name Subform Cars (plate, type, color) FORM B Lookup Customer Lookup Car in Form B, if I select the Customer "Mr. White", I would like to see in the lookup Car only the cars of Mr. White. Can I do this with lookup filters? How? Thanks
Hangs on "Adding..." when inserting new field to form
My items were all working correctly yesterday until mid-day when suddenly adding any new fields to the form (Drop down, Single line, Check box, anything) result in the page simply hanging with "Adding" for the field. If it is a lookup source, it does go through to steps to determine what the source will be and has the same result of the addition simply hanging there... Any suggestions?
Custom Schedules
Hi Guys, I have a requirement to create custom schedules that run every 14 days and every 30 days. It looks to me that I can't do this as the options are daily, weekly, monthly and yearly. Perhaps I'm missing something? Thanks for any assistance!
Subform Links in List Report
I have put Multiple SUbforms in my Parent Form but when I access the Report, List style, and i choose to access the Info in the SUbform Via a link in the Report i am no being shown the Data inputed into the fields. I am only getting Field names displayed when the link is clicked. Is there something i can do to have the Data included in the window generated by the Link?
How to learn input.vars or the Record ID within "On Delete" script?
Seems that both OnDelete.Validate, and OnDelete.Success, are unaware of the form's input vars?? The same scripts that work in OnAdd, and OnEdit, don't work when in OnDelete. Seems not even aware of its own record ID, at least not via input.ID. I must be missing something... :-) I have searched the dox and forum. How do I learn at LEAST the record ID, so I can look up the field values via x = <Form>[ID = input.ID]; ? In this our first brush with On Delete, we are updating some record counts successfully
Cant access my forms, blank page shows when trying to load any regular form
all of my forms are showing up blank
Retrieve data based on each Multiselect selection
hi, I have a multiselect field and I would like to retrieve the value from another view based on each multiselect selection and input it another field View1: Form: when user first selects the 1001 in the multiselect field then a script will retrieve the respective "Subs" value from view1 which is 3000 and input it to "Est.Subs-Selected Fips" and then when user selects next Fips value --1003 -- then the the "Est.Subs-Selected Fips" will be updated to 4000. Could anyone please help me on script ? Thanks
Kitting or multiple units, stumper
So I have multiple forms: Form1 Form2 Form3 Form4 Form2 contains a 1 to many relationship with Form1 example... in form2 I have UNIT A, which contains multiple Items from Form1 so UNIT A may have ITEM 1, ITEM 2 and ITEM 3, all with different quantities I want to be able to select UNIT A in Form3 and have it create an individual record in Form4 (I think thats what i want to do) for each Item in UNIT A Thanks
can you pass data from one form to another that the first form opened with an open url command?
can you pass data from one form to another that the first form opened with an open url command?
Look up field value different in view than when editing record?
Please take a look at the following screen shot. Highlighted in Red: Request_ID shown in view = 1185428000007018175 - m3steele@gmail44.com - 9 Highlighted in Green: Request_ID in edit record = 1185428000007018240 - - m3steele@gmail44.com - 9 What is wrong, why is this happening? Im not sure if the value is set wrong or what. I know the lookup field is referring to the correct record because of the part " m3steele@gmail44.com - 9" that is also included. These values are not in any other record in
Track number of times form completed by each person
Hello, I wonder if anyone out there can help me. The nice guys at Zoho support have tried to help me but unfortunately it doesn't allow me to do what I need. I have two forms: 1. SERVICE USER DETAILS (name, address etc). 2 WELLBEING They are linked through a look-up field on the wellbeing form (last name, first name, DOB). Each service user will complete the wellbeing form a number of times over a period of months/years. Each time they complete the form, I would like it to capture that this
Linking fields and forms
I am creating a client database for my Dog daycare and i am running into a couple problems with linking fields and forms. I have one form called Customer info and this form has fields for name, Dog's name, number, email, Daily Credits and a sub form for vaccination records. MY second form is called Dog account/payment history. This has a look up field for Dog'ss name, a radio button for Checkin/Checkout , a payment field, and a Credit field. I would like to link a couple items: 1. I would like to
using stateless form from data entry
I am using a stateless form for data entry (timesheet application) I would like to attach a file or image of the actual timesheet to each record i create with the stateless form. I know you can add a file with a normal form and copy it to another form when you submit.
Next Page